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

[Jason Spisak]

Tres and Seb,

Got rid of all the date FieldIndexes and am reindexing the new 
DateIndexes one at a time from the indexes tab, but I've hit a snag.

when I go to reindex 'expires' I get this error immediately:

Site error

This site encountered an error trying to fulfill your request. The 
errors were:
Error Details

Error Type
OverflowError

Error Value
integer multiplication

any thoughts on how to get past this?

> Jason Spisak wrote:
> 
>> You are right.  I've also got that permission turned off to take 
>> advantage of that part of the CMF workflow, which compounds the 
>> problem since it's site wide.  I'm building the individual DateIndexs 
>> now and when that's done, I'll check the performance (for my own 
>> edification if nothing else 8-).   Then I'll add that DateRange index 
>> and patch the CMF and check again.
>>
>> Do you guys want metrics?  If so, preferred tool/output method? 
>> (although my guess is, you already know how spiffy this makes things 8-)
> 
> 
> While *I* have a gut feel for what the result should be ("using 
> DateIndexes will ease most of your pain;  using a DateRange index will 
> blow your socks off"), it would be good to confirm that I'm right (or 
> not :) in public.
> 
> Tres.