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! Pedro _______________________________________________ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
