Dear Aleks,
Thank you very much for your time, Just to clarify on point #2 regarding close. What I understood from you if I have an application that is managing multiple embedded database ( let say 3 ) at the same time and needs to constantly run query / updates on these db's , then I just need to Open it once on startup and the close it whenever I'm done with database.
That's true. Opening database is a very fast operation, however, so a second, easier alternative is to implicitly open and query the database within XQuery expressions, as shown in the following two sample queries:
-- doc('dbname')/path/to/elements -- for $x in basex:db('dbname')/to/be/deleted return delete node $x
How about OPTIMIZE , I see you suggested to run it after all kinds of database updates, is it true ?
The optimize command refreshes meta data and index structures of a database, which might speed up the evaluation of new XQuery requests. We decided to make database optimization an optional feature to allow for a much faster evaluation of update queries.
Feel free to ask for more, Christian