Shadow - SQL queries / views optimization
Categories
Component ID
1107222
Component name
Shadow - SQL queries / views optimization
Component type
module
Maintenance status
Development status
Component security advisory coverage
not-covered
Downloads
5121
Component created
Component changed
Component body
Optimize SQL queries or views by using index tables which (partially) shadows the original query output. This differs from materialized views since the shadow table does only contain columns which are relevant for filtering / sorting. This module is capable of automatically rewriting SQL queries to speed them up using the shadow tables.
Related modules:
- DB Tuner CCK / views / MySQL optimalisation
- Materialized View API
- Views Optimized
This module is donated by the municipality of Breda and maintained by Dutch Open Projects.