Probably it is really a to big result set, then you can either formulate
querries that match fewer documents or you can limit the # results
returned by the db with the xpath function 'subsequence' , have a look
at the adequate sintax on w3schools.com
cheers
ph
webhiker wrote:
Using the Java API, I currently I keep getting an out of memory
exception :
"com.sleepycat.dbxml.XmlException: Error: Dbc::get: Cannot allocate
memory, errcode = DATABASE_ERROR"
when I launch an XPath query against the db with 50K xml documents in
it. All I'm retrieving are attributes, so in theory a list of 50k
attributes,
which IMO shouldn't be blowing up my JVM.
I'm currently running with JVM args -Xmx2048m and counting, but still
get the out of memory regardless.
Is it not possible to query the DB once it get's to this size? I was
hoping to push it to at leat 100K documents for our uses.
In case it helps, my query is :
for $result in collection('mycollection')/mydocument.root
order by $result/@myattribute
return $result/@myattribute
Has anybody encountered similar difficulties or has some advice for me?
Much appreciated.
wh
------------------------------------------
To remove yourself from this list, send an
email to xml-unsubscribe-E1rGyZxLSgzby3iVrkZq2A@xxxxxxxxxxxxxxxx
------------------------------------------
To remove yourself from this list, send an
email to xml-unsubscribe-E1rGyZxLSgzby3iVrkZq2A@xxxxxxxxxxxxxxxx
|
