This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:optimization:caches:home [2012/02/07 17:59] doc |
admin:optimization:caches:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 23: | Line 23: | ||
| * **Qualification Caching** - Omnidex is able to recognize patterns in queries, and will reuse qualifications from the previous query when appropriate. A common scenario involves a succession of SQL statements, each of which adds another piece of criteria. Another scenario involves queries that begin with requesting a count of rows, and then either requests for aggregations or detailed rows using the same criteria. In both of these cases, Omnidex is able to reuse earlier qualifications, greatly improving performance. | * **Qualification Caching** - Omnidex is able to recognize patterns in queries, and will reuse qualifications from the previous query when appropriate. A common scenario involves a succession of SQL statements, each of which adds another piece of criteria. Another scenario involves queries that begin with requesting a count of rows, and then either requests for aggregations or detailed rows using the same criteria. In both of these cases, Omnidex is able to reuse earlier qualifications, greatly improving performance. | ||
| - | * **Filesystem Caching** - Omnidex relies on file caching from the operating system in order to achieve high performance. This file caching is performed automatically by the operating system and benefits Omnidex, but only if certain memory requirements are met. | + | * **Filesystem Caching** - Omnidex relies on filesystem caching managed by the operating system in order to achieve high performance. This filesystem caching is automatic and benefits Omnidex, but only if certain memory requirements are met. |
| - | All of these caches are designed to support standard Omnidex applications, and they are activated automatically. These caches also reflect that Omnidex is most frequently used in read-only environments. These caches can be deactivated in read-write environments as needed. | + | All of these caching techniques are available to all Omnidex applications, and they are activated automatically. These techniques also take advantage of the fact that Omnidex is most frequently used in read-only environments. |
| ===== ===== | ===== ===== | ||