Re: [bdbxml] Redux: One Container Or Many

I have to echo David's question about possible DB corruption.

As for the container question, at this time, queries cannot be
run across multiple containers.  That would need to be done at the
application level.

As for speed, the product works best with a large number of relatively
small documents in a single container.  I would expect that once
the database is intact, if the indexes are set up correctly, you will
see very good response.

George

> (Redux: My last posting of this question listed the wrong number of MB 
> for the total of the textbase files. I was looking at an incorrect file 
> listing.)
> 
> Which is faster for query access, one container with many documents in 
> it, or many containers with only one or a few documents in each container?
> 
> Based on my experience so far with my single container that has all my 
> documents (totalling about 58 MB of data), queries against this are VERY 
> slow, even with indexing (unleess I did my indexing incorrectly).
> 
> Without any indexing, this query took 6 and a half minutes.
> 
> With indexing, I got no query results, only this error after quite a while:
> 
> Exception in thread "main" com.sleepycat.dbxml.XmlException: Error: 
> Dbc::get: DB_PAGE_NOTFOUND: Requested page not found: DB_PAGE_NOTFOUND: 
> Requested page not found, errcode = INDEXER_PARSER_ERROR
>          at 
> com.sleepycat.dbxml.dbxml_javaJNI.XmlContainer_queryWithXPath(Native Method)
>          at 
> com.sleepycat.dbxml.XmlContainer.queryWithXPath(XmlContainer.java:153)
>          at WWPQueryDocument.doQuery(WWPQueryDocument.java:44)
>          at WWPQueryDocument.main(WWPQueryDocument.java:32)
> 
> There are a total of 230 documents. No single document is bigger than 
> 1.7 MB, and only four or five are larger than a megabyte.