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

[Jason Spisak]

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
> 
> 
>