Skip to Main Content

Berkeley DB Family

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbxml memory consumption

614324Jan 15 2008 — edited Jan 25 2008
I have a query that returns about 10MB worth of data when run against my db -- it looks something like the following

'for $doc in collection("VcObjStore")/doc
where $doc[@type="Foo"]
return <item>{$doc}</item>'

when I run this query in dbxml.exe, I see memory footprint (of dbxml.exe) increase 125MB. Once query finishes, it comes back down.

I expected memory consumption to be somewhat larger than what the query actually returns but this seems quite extreme.

Is this behavior expected? What is a general rule of thumb on memory usage with respect to result size (is it really 10x)? Any way to make it less of a hog?


Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 22 2008
Added on Jan 15 2008
13 comments
1,436 views