Re: [basex-talk] re-sort database

2013-03-14 Thread Cerstin Elisabeth Mahlow
Hi, Am 14.03.2013 um 00:02 schrieb Liam R E Quin l...@w3.org: On Wed, 2013-03-13 at 22:29 +0100, Christian Grün wrote: You could try to export your data and create a new database without updatable index structures; this could also speed up your updates. Maybe it even allows you to update

Re: [basex-talk] re-sort database

2013-03-13 Thread Wendell Piez
Christian, Thanks, but I was hoping I could lure you (or someone else) into suggesting what the syntax for a window clause might look like here! :-) Since they are something I haven't mastered yet. (Any takers?) Cheers, Wendell On Wed, Mar 13, 2013 at 10:25 AM, Christian Grün

Re: [basex-talk] re-sort database

2013-03-13 Thread Christian Grün
Hi Cerstin, However, my real data has about 140 000 of such entries and about 30 000 of such secondqueries, it's all in one database. Which is probably too big. true; it may well be that the total amount of update operations is too large to be processed in a single step. I would advise to

Re: [basex-talk] re-sort database

2013-03-13 Thread Liam R E Quin
On Wed, 2013-03-13 at 22:29 +0100, Christian Grün wrote: Hi Cerstin, [...] You could try to export your data and create a new database without updatable index structures; this could also speed up your updates. Maybe it even allows you to update all nodes in a single run. I already set

Re: [basex-talk] re-sort database

2013-03-12 Thread Christian Grün
Hi Cerstin, the following query may help: for $entry in $doc//entry let $next := $entry/following-sibling::entry[1] let $sc := $entry/following-sibling::secondquery [empty($next) or . $next] return ( insert nodes $sc into $entry, delete nodes $sc ) Cheers, Christian