[Zope-CMF] Optimizing catalog queries

Seb Bacon seb at jamkit.com
Mon Nov 10 12:48:33 EST 2003


Gitte Wange wrote:
>>Okay :-)
>>I have changed the indexes now but couldn't change the index for 'expires'.
>>I simply got an Overflow Error, because the date it tried to index is
>>9998/12/31 and the _convert method raised an overflow error. I can see that
>>there is a long time untill year 9998 but shouldn't it be able to handle
>>such a date ?
>>Will try an Google for answers.
> 
> 
> Google found the answer for me - a collector issue #710 from december last 
> year :-(
> Doesn't look like there's a fix for this comming up ...

A quick hack which would almost certainly work for you: try changing the 
line which raises an OverflowError to "return sys.maxint".





More information about the Zope-CMF mailing list