I have a database about 200 MB in size made up of approximately 150 000 documents of similar size and structure as children of the root node.

When I run the following script in basexgui a significant amount of memory is consumed (over 1 GB if I'm reading the display correctly), but I do get a result:

for $doc in db:get('docs')

return $doc update {

    delete node .//*[local-name() = ('A', 'B', 'C', 'D')]

}

When I run it over basexhttp I get a java.lang.OutOfMemoryError: Java heap space. I have increased the memory available to the JVM to 4 GB but this has not affected the failure of the script.

How can I resolve this? Is there some rewriting of the script that would help, or is it more specific to basexhttp?

Many thanks,

Jack