Re: [basex-talk] fn:doc weirdness with imported files

Hi Marc, > When I have the database closed in the GUI > > base-uri(doc('F:/tmp/foo.xml')) => file:///F:/tmp/foo.xml > > And when I open the database "foo" from the GUI > > base-uri(doc('F:/tmp/foo.xml')) => /foo/foo.xml > > Is that right? I wouldn’t say so ;) As somewhat usual, I

Re: [basex-talk] Gravierende Performance-Einbüße bei Persistierung von mehr als 5000, 160 KB große XML Datenstrukturen.

Hi Lucian, I couldn’t run your code example out of the box. 24 hours sounds pretty alarming, though, so I have written my own example (attached). It creates 50.000 XML documents, each sized around 160 KB. It’s not as fast as I had expected, but the total runtime is around 13 minutes, and it only

Re: [basex-talk] Gravierende Performance-Einbüße bei Persistierung von mehr als 5000, 160 KB große XML Datenstrukturen.

Hi Dirk, of course, querying millions of data entries on a single database rise problems. This is equally problematic for all databases, not only for the BaseX DB and certain storing strategies will be mandatory at production time. The actual problem is, that adding 50.000 of 160 KB xml

Re: [basex-talk] fn:doc weirdness with imported files

... am I missing something? So this db:node-id($node) should raise an error in case $node is not a database node. However in the GUI and in the command-line client. db:node-id(doc('F:/tmp/afile.xml')) => 0 db:node-id(doc('F:/tmp/afile.xml')/*) => 1 only requirement is that

[basex-talk] fn:doc weirdness with imported files

Hi all, Happy new year btw! I got bitten by something and can't explain this behaviour. So the situation is that I have an XML file on the file system in F:/tmp/foo.xml I also have this file imported into a database named "foo" (and the path "/foo.xml". Now in the GUI (and on 8.5.3) I have

Re: [basex-talk] Gravierende Performance-Einbüße bei Persistierung von mehr als 5000, 160 KB große XML Datenstrukturen.

Hi Lucian, sorry, I obviously forgot a very important word: "not". I would NOT expect 100,000 documents to be added to be much of a problem. Sorry for the confusion. The log file is interesting, it certainly looks like the performance is degrading. I can't say much about it, but I am sure

Re: [basex-talk] Gravierende Performance-Einbüße bei Persistierung von mehr als 5000, 160 KB große XML Datenstrukturen.

Hi Dirk, thanks for your fast reply :) Regarding the performance measure, I've forgot to mention, that I've based my affirmations on the protocol entries from the BaseX log file (see attached basex.log). The intention of the System.out made in each iteration, is just to protocol the order

Re: [basex-talk] Gravierende Performance-Einbüße bei Persistierung von mehr als 5000, 160 KB große XML Datenstrukturen.

Hello Lucian, please be aware that this is an English-speaking mailing list as we have many users from all over the world and the mailing list is intended to help everyone. But as most of our team members are German (well, and Bavarians...) we of course understand it. Hence, I answer in English