This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
admin:features:rollups:home [2011/01/24 15:26] 127.0.0.1 external edit |
admin:features:rollups:home [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
~~NOTOC~~ | ~~NOTOC~~ | ||
+ | |||
{{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
Line 6: | Line 7: | ||
===== Rollup Tables ===== | ===== Rollup Tables ===== | ||
- | **[[admin:features:rollups:home|Overview]]** -> [[admin:features:rollups:design|Design]] -> [[admin:features:rollups:create|Creation]] -> [[admin:features:rollups:indexing|Indexing]] -> [[admin:features:rollups:optimization|Optimization]] | + | **[[admin:features:rollups:home|Overview]]** | [[admin:features:rollups:design|Design]] | [[admin:features:rollups:create|Creation]] | [[admin:features:rollups:indexing|Indexing]] | [[admin:features:rollups:optimization|Optimization]] |
---- | ---- | ||
Line 12: | Line 13: | ||
==== Overview ==== | ==== Overview ==== | ||
- | When working with very large database, there are lots of different techniques that can be used to improve performance. Omnidex provides a variety of partitioning strategies that can be used to quickly reduce a large database to a small result set. Omnidex provides specialized bitmap indexes geared for large databases. A variety of other techniques, from multi-column indexing, to Hashed Data Caching, to reusing Omnidex ID lists, all help extract the best performance possible from queries against large databases. | + | When working with very large databases, there are lots of different techniques that can be used to improve performance. Omnidex provides a variety of partitioning strategies that can be used to quickly reduce a large database to a small result set. Omnidex provides specialized bitmap indexes geared for large databases. A variety of other techniques, from multi-column indexing, to Hashed Data Caching, to reusing Omnidex ID lists, all help extract the best performance possible from queries against large databases. |
An additional technique is being added to Omnidex to speed performance on large databases. Omnidex will now support the use of Rollup Tables. Rollup Tables will allow certain queries that involve counts and aggregations to be processed significantly faster. | An additional technique is being added to Omnidex to speed performance on large databases. Omnidex will now support the use of Rollup Tables. Rollup Tables will allow certain queries that involve counts and aggregations to be processed significantly faster. |