* [[topbar |Table of Contents]] * [[intro:overview:what|Introduction]] * [[install:home|Installation]] * [[install:editions|Product Editions]] * [[install:requirements|System Requirements]] * [[install:platforms|Supported Platforms]] * [[install:guides:home|Installation Guides]] * [[install:licensing:home|Licensing]] * [[install:releases:home|Release Notes]] * [[admin:home|Administration]] * [[admin:admin:home|Administration Basics]] * [[admin:admin:architecture:home|Omnidex Architecture]] * [[admin:admin:applications:home|Building Applications]] * [[admin:basics:home|Omnidex Fundamentals]] * [[admin:basics:environments:home|Omnidex Environments]] * [[admin:basics:sqlengine:home|Omnidex SQL Engine]] * [[admin:basics:updates:home|Omnidex Updates]] * [[admin:basics:network:home|Network Services]] * [[admin:indexing:home|Omnidex Indexing]] * [[admin:indexing:concepts:home|Indexing Concepts]] * [[admin:indexing:indexes:home|Indexing Options]] * [[admin:indexing:creation:home|Index Creation]] * [[admin:indexing:strategies:home|Indexing Strategies]] * [[admin:indexing:activecounts:home|ActiveCounts]] * [[admin:indexing:powersearch:home|PowerSearch]] * [[admin:indexing:autocomplete:home|AutoComplete]] * [[admin:indexing:text:home|Omnidex Text]] * [[admin:features:home|Omnidex Features]] * [[admin:features:snapshots:home|Omnidex Snapshots]] * [[admin:features:grids:home|Omnidex Grids]] * [[admin:features:rollups:home|Rollup Tables]] * [[admin:features:geo:home|Geographic Searches]] * [[admin:features:expressioncols:home|Expression Columns]] * [[admin:features:segments:home|Omnidex Segments]] * [[admin:features:attach:home|Attaching Data]] * [[admin:features:export:home|Exporting Data]] * [[admin:optimization:home|Optimizing Queries]] * [[admin:optimization:plans:home|Query Plans]] * [[admin:optimization:caches:home|Dynamic Caches]] * [[admin:optimization:config:home|Configuring Omnidex]] * [[integration:home|Integration]] * [[integration:rdbms:home|Relational Databases]] * [[integration:rdbms:oracle:home|Oracle]] * [[integration:rdbms:sqlserver:home|SQL Server]] * [[integration:rdbms:mysql:home|MySQL]] * [[integration:rdbms:odbc:home|Generic ODBC]] * [[integration:rawdata:home|Raw Data Files]] * [[integration:rawdata:fixed:home|Fixed-length Files]] * [[integration:rawdata:delimited:home|Delimited Files]] * [[integration:rawdata:ost:home|Standalone Tables]] * [[dev:home|Development]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:overview|Overview]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[dev:connections:home|Connection Strings]] * [[dev:odbc:home|ODBC Interface]] * [[dev:jdbc:home|JDBC Interface]] * [[dev:debugging:home|Logging/Debugging]] * [[programs:home|Programs]] * [[programs:odxsql:home|OdxSQL]] * [[programs:odxnet:home|OdxNet]] * [[appendix:home|Appendix]] * [[dev:sql:home|Omnidex SQL]] * [[dev:sql:statements:home|Statements]] * [[dev:sql:functions:home|Functions]] * [[dev:sql:examples:home|Examples]] * [[http://www.omnidex.com/download/|Downloads]] * [[support:home|Support]]

~~NOTOC~~ {{page>:top_add&nofooter&noeditbtn}} ====== Administration: Administration Basics ====== ===== Building Omnidex Applications ===== [[admin:admin:applications:design|Design]] | [[admin:admin:applications:prototype|Prototype]] | [[admin:admin:applications:development|Development]] | [[admin:admin:applications:testing|Testing]] | [[admin:admin:applications:staging|Staging]] | [[admin:admin:applications:production|Production]] | **[[admin:admin:applications:optimization|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 [[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. There are several common strategies for optimizing an Omnidex application: - [[#Reviewing_new_queries|Reviewing new queries]] - [[#Optimizing_slow_queries|Optimizing slow queries]] - [[#Monitoring_statistics|Monitoring statistics]] - [[#Distributing_and_scaling_applications|Distributing and scaling applications]] === Reviewing New Queries === As applications change, so do the queries. Queries that involve new tables or columns should be optimized using the same techniques described in the [[admin:admin:applications:design|Design]] section. === 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 [[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. === Monitoring Statistics === Omnidex maintains statistics of how frequently each index is used. Early in the life of an application, it is common to add more indexes than are needed. Administrators can remove unused indexes to conserve disk space and shorten build time. Omnidex statistics will also show the cardinalities of tables, indicating when an Omnidex Grid may be of benefit. === Distributing and Scaling Applications === Large Omnidex databases may have been deployed using an Omnidex Grid. Omnidex Grids may require new nodes, and nodes may be distributed to a variety of servers. As applications grow further, it may be beneficial to distribute copies of the data and the indexes using Omnidex Snapshots. ==== ==== **[[admin:admin:applications:production|Prev]]** ====== Additional Resources ====== See also: {{page>:admin:admin:see_also&nofooter&noeditbtn}} {{page>:bottom_add&nofooter&noeditbtn}}

Back to top
admin/admin/applications/optimization.txt ยท Last modified: 2016/06/28 22:38 (external edit)
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0