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]