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

30 Jan 2004

      Seb,

thanks!   i'll give that a shot.  i also thought of adding daterange 
indexes for the calendar portion or things.  does that also garner any 
speed improvement?

Seb Bacon wrote:
...
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