Hi,
I too have a question about database updates, in particular Fabrice's remark that "The GUI may not be the best place to run updates, did you try the basex command line tools ?"
I have an update that is working okay from the GUI, but I wouldn't mind it if it were faster. :-)
Is simply invoking the same XQuery using RUN from the command line all I have to do to get the benefits of using the CL?
In addition: my update query is configured with a bit of XML, something like
declare variable $build-db := <build db="new"> <source db="old1"/> <source db="old2"/> <source db="old3"/> </build>;
(Of course it's more complicated than this but you get the essence.)
But I can't pass this XML into a function to perform the updates, since I can't put update operations into a function at all. (So the XML is piled into a global variable, which the update operations reference.)
Do you have any suggestions for how I can encapsulate the updating logic and also make it configurable externally like this? And run it from the command line or a script for speed and efficiency?
Thanks, Wendell
-- Wendell Piez | http://www.wendellpiez.com XML | XSLT | electronic publishing Eat Your Vegetables _____oo_________o_o___ooooo____ooooooo_^