[Zope-dev] ZCatalog fast as admin, dog slow as anonymous and other users

[Seb Bacon]

Jason Spisak wrote:
> Zopistas,
> 
> My ZCatalog is fast as admin, but dog slow as anonymous and other users. 
>  Anyone had this same experience?  Details:

This is certainly to do with queries which run against FieldIndexes only 
for anonymous users.  This is something the CMF does (e.g. expires and 
effective dates only applied for anonymous).

FieldIndexes are really bad for DateTimes.  Delete your date-related 
FieldIndexes and replace them with DateIndexes.

seb