https://www.omnidex.com/docs/v54/ 2026-04-30T08:12:46+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:optimization:caches:cachequal&rev=1467153531&do=diff Administration: Optimizing Queries Dynamic Caches Overview | Hashed Data Caching | Qualification Caching | Filesystem Caching ---------- Qualification Caching Omnidex optimizes most statements by qualifying rows using the Omnidex indexes. Each qualification searches one or more indexes and then writes index pointers to a temporary file. This approach is much faster than searching the data directly, but it can also be further optimized. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:optimization:caches:filesystem&rev=1467153531&do=diff Administration: Optimizing Queries Dynamic Caches Overview | Hashed Data Caching | Qualification Caching | Filesystem Caching ---------- Filesystem Caching Omnidex benefits greatly from the filesystem caching that is automatically managed by the operating system. Omnidex purposefully maintains small index files and uses standard file system calls in order to insure the best caching by the operating system. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:optimization:caches:hdc&rev=1467153531&do=diff Administration: Optimizing Queries Dynamic Caches Overview | Hashed Data Caching | Qualification Caching | Filesystem Caching ---------- Hashed Data Caching Omnidex has several approaches to choose from when joining tables. Standard Omnidex indexes can be used to join tables, and pre-joined indexes can be used to accelerate joins between parents tabled and child tables. Omnidex can use the underlying database's indexes to perform table joins. Omnidex can use a sort/merge technique to joi… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=admin:optimization:caches:home&rev=1467153531&do=diff Administration: Optimizing Queries Dynamic Caches Overview | Hashed Data Caching | Qualification Caching | Filesystem Caching ---------- Overview Caching is a common method of optimizing queries in Omnidex, similar to the relational databases. Omnidex works with caching in three areas: * Data Caching - Omnidex creates temporary caches of data during some query processing in order to minimize access to the underlying database. Typically, this occurs when smaller tables are joined to fro…