fastest way to add/replace/delete xml

Dear all, I have to store and replace xml pieces, and am wondering what can be the fastest way to achieve that task. - Add provided files containing several xml pieces, and then use xquery update to replace nodes ? - Or split files to add a document per xml piece, and then use db:replace ? These databases have size near the physical limit. Regards, Fabrice Etanchaud Questel-Orbit

Hi Fabrice, there’s probably no general answer to that, so I suggest you need to try what’s working best for you. As a general hint, it will always be faster to replace multiple contents via a single query, as this gives the optimizers better chances to perform required operations only once. Next, adding will be much faster than replacing documents, because existing data needs not be found in the database (finding data usually takes more space than adding new data). Hope this helps, Christian