https://www.omnidex.com/docs/v54/ 2026-04-29T20:43:58+0000 https://www.omnidex.com/docs/v54/ https://www.omnidex.com/docs/v54/lib/tpl/simple/images/favicon.ico text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:activecounts:example&rev=1467153531&do=diff Administration: Omnidex Indexing ActiveCounts Overview | Example | SQL | Optimization | Tips ---------- Example Sometimes a picture is worth a thousand words. In this example of ActiveCounts, a web page is allowing a user to qualify a subset of rows from a database for an eventual mailing. This database has nearly 300 million rows text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:activecounts:home&rev=1467153531&do=diff Administration: Omnidex Indexing ActiveCounts Overview | Example | SQL | Optimization | Tips ---------- Overview Counts inform us. When people use web applications, their experience is substantially altered by the mere presence of counts. Think about the websites that you have visited recently, especially those that access databases. Shopping sites. Forums. Libraries. When you perform searches, some of those sites show you counts along the way. Others do not. There is a difference. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:activecounts:optimization&rev=1467153531&do=diff Administration: Omnidex Indexing ActiveCounts Overview | Example | SQL | Optimization | Tips ---------- The Optimization Behind ActiveCounts The SQL statements that allow ActiveCounts are fairly ordinary. They are primarily a succession of grouped aggregations, with an additional piece of criteria added at each step. The key to ActiveCounts lies in the optimization of these queries. Omnidex has special optimizations for this particular kind of query. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:activecounts:sql&rev=1467153531&do=diff Administration: Omnidex Indexing ActiveCounts Overview | Example | SQL | Optimization | Tips ---------- The SQL Behind ActiveCounts The example on the previous page demonstrated ActiveCounts in a web page; however, ActiveCounts is not a set of web controls. ActiveCounts is really just a powerful set of SQL statements that are highly optimized using the Omnidex indexes. This means that ActiveCounts can be implemented in any application that calls SQL. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:indexing:activecounts:tips&rev=1467153531&do=diff Administration: Omnidex Indexing ActiveCounts Overview | Example | SQL | Optimization | 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