[Zope-CMF] Optimizing catalog queries
Seb Bacon
seb at jamkit.com
Mon Nov 10 06:03:22 EST 2003
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
More information about the Zope-CMF
mailing list