On 9 July 2015 at 09:16, Chetan Mehrotra <[email protected]> wrote:
> On Thu, Jul 9, 2015 at 12:45 PM, Marcel Reutegger <[email protected]> > wrote: > > - Data in Oak is multi-versioned. It must be possible to query > > nodes at a specific revision of the tree. > > To add - That also makes it difficult to use Mongo indexes as the > index itself is versioned. So instead of just indexing property 'foo' > you need to index it for every revision > Won't compound indexes work ? { _id : 1, _modified: 1, _revision: 1 } ? They are bigger. _id is 211 bytes per entry average _modified: _id is 233 _revision, _modified, _id is probably close to 400 bytes as _revision is a string. I guess the way of telling is to generate the index on a test database and see what impact it has. Best Regards Ian > > Chetan Mehrotra >
