David Glick wrote:
> Pedro Ferreira wrote:
>> Hello all,
>> So, I've been experimenting with a new structure for our date indexes,
>> and I was considering using an IOBTree that would map integer timestamps
>> to BTree-based sets. As for the sets, I considered two options:
> Be careful with using timestamps as IOBTree keys. By default this type
> of BTree uses the system integer, which on many systems is 32 bits.
> That means that you'll overflow the maximum allowed key for timestamps
> beyond the year 2038. It won't even give an error; it will just
> silently overflow and overwrite existing values in the BTree.
Yes, I know. That's one of the reasons I'm using YYYYmmdd integers
instead (the other one being i only need 1 day resolution).
Thanks a lot for the tip!
For more information about ZODB, see the ZODB Wiki:
ZODB-Dev mailing list - ZODB-Dev@zope.org