Hi Christian, oops, I'm sorry. It's attached. There are text and attribute indexes.
With kind regards, Menashè
On 07/14/2015 09:32 AM, Christian Grün wrote:
Hi Menashè,
The attached log file is empty. Maybe it's sufficient if you provide us with the query and give us information on the query compilation (are any indexes used?).
C.
On Mon, Jul 13, 2015 at 3:32 PM, Menashè Eliezer meliezer@ogs.trieste.it wrote:
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è