Re: [bdbxml] collections

George Feinberg <[email protected]> Fri, 5 Aug 2005 14:08:23 -0400
Newsgroups gmane.comp.db.dbxml.general
Message-ID <[email protected]>
> Thanks for the reply.... an additional question about container types.
> From what I have read my sitiation with a large number of very  
> small documents
> where I will always be returning the whole document through a query  
> and
> replacing the whole document for updates, the best choice is to use  
> a Wholedoc
> container. Is that correct? Also it is still possible to define  
> indexes on nodes
> and attributes when Wholedoc is used?

Yes, for indexing.
Regarding storage type, even though the docs are small,
they still need to be parsed during queries.
Indexes narrow the search to a (hopefully small) set of documents,
but most queries require further navigation.

The question becomes, which creates more overhead:
1.  parsing the docs that meet the index criteria
2   serializing the result docs from node storage

The best thing is to try both and see which works best
for you.  Your results will vary with query, number of results,
etc.  Generally queries run faster on node storage containers.
Parsing during queries is not particularly cheap.  Over time,
we hope to speed that up by reducing fixed overhead.

Regards,

George



------------------------------------------
To remove yourself from this list, send an
email to [email protected]