TCustomDataStore.MaxCells Property

Limits the number of cells that can be included in the cache at any one time.

Pascal

property MaxCells: Integer;

C++

__property int MaxCells;

Description

Use MaxCells to limit the memory usage of the crosstabulated data store. Memory consumption increases geometrically with each dimension that is cached in the multidimensional array and linearly with each summary. MaxCells prevents too many dimensions or summaries from being cached at once.

When the ActiveFlag property of a dimension or summary is diActive, it is always added to the cache. When the ActiveFlag property of a dimension or summary is diAsNeeded, it can be added only if it does not cause the number of cells to exceed MaxCells. The data store swaps in as-needed dimensions and summaries when they are used by the decision source, making room, if necessary, by swapping out closed dimensions or summaries that are not current.

Note: Be sure to set MaxCells to a value big enough to accommodate all active dimensions and summaries plus the number of as-needed dimensions and summaries that can be open at one time.