#89: Optimize catalog queries for dates
by
Alexander Limi
—
last modified
Jun 11, 2006 12:22 AM
Merge the CatalogOptimizier into Plone 2.1. It's changing some indexes to use special optimized version for dates and date ranges
- Proposed by
- Christian Heimes
- Proposal type
- Architecture
- Repository branch
- plip89-catalog-optimizer
- State
- completed
Motivation
Catalog queries for dates - especially effective and expired date - are horrible inefficient with standard indexes. DateIndex and DateRangeIndex is speeding up the queries and the index size a lot.
Assumptions
CMF 1.4.5+
AT 1.3+
Proposal
Replace several date specific indexes with Date or DateRangeIndexes
Change the portal query method
Implementation
Move the code of CatalogOptimizer from cvs to migration + plones catalog tool.
CMFDefault DublinCore CEILINGDATE