Hello, Creating a database of partial xml documents had almost no effect. Therefore I've created a database with very simple xml structure. I'm attaching an example (demo.xml). BaseX version: 8.2.2 Number of documents: 374739
However, the attached query takes 4 seconds (attached simple_query.log). I don't know if it's considered a normal performance, but my real query is different: I'm copying all the documents which correspond to my query to a newly created temporary collection, for having faster processing for this subset: reporting, ecc. Adding to db (Remote Java client): 12 sec. Optimising the db (Remote Java client): 23 sec. Both the Java client and BaseX server are installed on powerful servers. Are these numbers normal? The attached results are based on a local client (Using the BaseX GUI).
In the future, I should have even much more documents to handle... Any ideas? I can also change the scheme of my new xml.
As for the idea of creating a new temporary db, I'm checking an alternative: return in one query all what I need, including reports, all in one xml.
With kind regards, Menashè