[Zope-CMF] Optimizing catalog queries

[Seb Bacon]

Gitte Wange wrote:
> Hello,
> 
> I have a CMF site that has been running a little slow but after I changed the 
> values for the cache parameters, it's running much faster.
> The only thing slowing the forintpage down now, is a calendar on the 
> frontpage.
> 
> I have been reading about the DateIndex and DateRangeIndex which should 
> improve speed a bit ?

It depends on how many objects are indexed, but I've seen the rendering 
time of pages improve from 12 seconds to <1 second when I've used 
DateIndexes instead of FieldIndexes.

You should always see an improvement using DateIndexes or 
DateRangeIndexes over FieldIndexes.  Don't forget to change effective, 
expires, modified etc into DateRangeIndexes too.

DateRangeIndex is for things which should be between two dates, e.g. 
time 'A' where 'effective' < 'A' < 'expires'; google for examples.

seb