We should consider making the current hard-coded value of 50 in the LoadTableStatistics method configurable by introducing a tableBatchSize parameter. This enhancement is similar to the columnBatchSize parameter that was added to the LoadColumnStatistics method in https://github.com/sql-bi/VertiPaq-Analyzer/issues/131
One other observation that I made is that similar logic is used in the LoadTableStatistics method where 50 is hard coded. var loopTables = tableList.SplitList(50);
We should consider making the current hard-coded value of 50 in the
LoadTableStatistics
method configurable by introducing atableBatchSize
parameter. This enhancement is similar to thecolumnBatchSize
parameter that was added to theLoadColumnStatistics
method in https://github.com/sql-bi/VertiPaq-Analyzer/issues/131Originally posted by @corycundy in https://github.com/sql-bi/VertiPaq-Analyzer/issues/131#issuecomment-2278331191