Overview | Example | SQL | Optimization | Tips

The following tips are helpful when implementing ActiveCounts in applications:

• ActiveCounts works best for lower-cardinality data since that produces a reasonable set of choices to display to the user. Criteria for high-cardinality data can be interwoven, but then it is best to just prompt for the criteria rather than display choices. Consider using the AutoComplete feature for these criteria since it will show choices and can also show counts.

• The most important step in setting up ActiveCounts on a database is insuring that all statements are going to be completely optimized using Omnidex indexing. It is worthwhile to obtain a query plan for each query to insure that it is fully optimized.

• When ActiveCounts is used on an Omnidex Grid, it can help performance to present the column used as the grid's Partition Qualifier first. Once the Partition Qualifier has been provided, the scope of the searches is substantially reduced.

• When ActiveCounts is used on an Omnidex Grid, it can help performance to have Rollup Tables on each node, and also have Rollup Tables on a Rollup Node.

Prev

See also: