This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
admin:admin:applications:optimization [2011/04/12 17:59] 127.0.0.1 external edit |
admin:admin:applications:optimization [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ~~NOTOC~~ | ~~NOTOC~~ | ||
| + | |||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| Line 13: | Line 14: | ||
| ==== Optimization ==== | ==== Optimization ==== | ||
| - | Omnidex applications are constantly evolving and the queries that are submitted to an application can change over time. The Omnidex indexing strategy must evolve with the application to insure that performance is maintained. This requires reviewing new queries and monitoring slow queries. It is also important to monitor index usage statistics to eliminate indexes that are no longer needed. | + | Omnidex applications are constantly evolving and the queries that are submitted to an application can change over time. The Omnidex indexing strategy must evolve with the application to insure that performance is maintained. This requires reviewing new queries and monitoring slow queries. It is also important to [[admin:monitor:statistics:home | monitor index usage statistics]] to eliminate indexes that are no longer needed. |
| As Omnidex applications grow, it may become necessary to distribute and scale the application. A database may need to evolve into an Omnidex Grid, or an existing Omnidex Grid may require more nodes or servers. | As Omnidex applications grow, it may become necessary to distribute and scale the application. A database may need to evolve into an Omnidex Grid, or an existing Omnidex Grid may require more nodes or servers. | ||
| Line 31: | Line 32: | ||
| === Optimizing Slow Queries === | === Optimizing Slow Queries === | ||
| - | Omnidex maintains a list of the slowest queries on each server. These queries are prime candidates for optimization using the same techniques described in [[admin:admin:applications:design|Design]]. Omnidex also provides tools for logging all queries in an application. This more comprehensive log allows a deeper analysis of the performance of queries and can be used to identify patterns of queries that require further optimization. | + | Omnidex maintains a list of the slowest queries on each server. These queries are prime candidates for optimization using the same techniques described in [[admin:admin:applications:design|Design]]. Omnidex also provides [[admin:monitor:statements:home | tools for logging]] all queries in an application. This more comprehensive log allows a deeper analysis of the performance of queries and can be used to identify patterns of queries that require further optimization. |