This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
admin:indexing:activecounts:tips [2011/01/21 04:48] els created |
admin:indexing:activecounts:tips [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ~~NOTOC~~ | ||
| + | |||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| Line 16: | Line 18: | ||
| ==== Implementation Tips ==== | ==== Implementation 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 [[admin:indexing:autocomplete:home|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 [[admin:optimization:plans:home|query plan]] for each query to insure that it is fully optimized. | ||
| + | |||
| + | * When ActiveCounts is used on an [[admin:features:grids:home|Omnidex Grid]], it can help performance to present the column used as the grid's [[admin:features:grids:partitions|Partition Qualifier]] first. Once the Partition Qualifier has been provided, the scope of the searches is substantially reduced. | ||
| + | |||
| + | * When ActiveCounts is used on an [[admin:features:grids:home|Omnidex Grid]], it can help performance to have [[admin:features:rollups:home|Rollup Tables]] on each node, and also have Rollup Tables on a Rollup Node. | ||