On Tue, Jul 13, 2010 at 4:35 AM, Pedro Ferreira
>>> I am currently trying to devise a way to index and retrieve some
>>> millions of objects according to their modification date/time.
> So, in a relational DB i would do something like:
> SELECT * FROM table WHERE timestamp >= X AND timestamp <= Y
> Since I cannot do this with ZODB, I'd have to have a BTree, indexed by
> timestamp... however, as you said, if I want "to the second"
> granularity, I will rarely have two items with the same key (which makes
> it pretty useless).
If you use the timestamp as the key and you want to retrieve all values
between two timestamps (inclusive), you can do
For more information about ZODB, see the ZODB Wiki:
ZODB-Dev mailing list - ZODB-Dev@zope.org