Personal tools
You are here: Home → Products → Plone → Roadmap → #89: Optimize catalog queries for dates
Navigation
Log in


Forgot your password?
New user?
 
Document Actions

#89: Optimize catalog queries for dates

Contents
  1. Motivation
  2. Assumptions
  3. Proposal
  4. Implementation
by Alexander Limi — last modified June 11, 2006 - 00:22
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

Posted by Christian 'Tiran' Heimes at March 26, 2005 - 23:40

CEILING DATE of DublinCore is still patched by CatalogTool.

For any issues with the web site functionality, please file a ticket.

Please consult the policy on plone.org content if you want your content published on this site.

Servers and hosting by