Re: [basex-talk] Help with a Query/Performance

2020-01-21 Thread Tom Rauchenwald (UNIFITS)
talk] Help with a Query/Performance I missed to do the obvious next step. The following query is evaluated in a few milliseconds: declare variable $OFFSET1 := 3; declare variable $OFFSET2 := 2; let $container := db:open('tr-test')/Container let $message := $container/*:MessageA[$OFFSET1]

Re: [basex-talk] Help with a Query/Performance

2020-01-20 Thread Christian Grün
I missed to do the obvious next step. The following query is evaluated in a few milliseconds: declare variable $OFFSET1 := 3; declare variable $OFFSET2 := 2; let $container := db:open('tr-test')/Container let $message := $container/*:MessageA[$OFFSET1] let $detail :=

Re: [basex-talk] Help with a Query/Performance

2020-01-20 Thread Christian Grün
Dear Tom, If you have large elements, it will usually be faster to create new elements. Here’s one way to do it: let $offset1 := 3 let $offset2 := 2 let $container := db:open('tr-test')/Container return element Container { (: add meta data elements :)

Re: [basex-talk] Help with a Query/Performance

2020-01-20 Thread Zimmel, Daniel
be an alternative, if there is something that stops you from reconstructing. Daniel Von: Tom Rauchenwald (UNIFITS) Gesendet: Montag, 20. Januar 2020 10:01 An: basex-talk@mailman.uni-konstanz.de Betreff: [basex-talk] Help with a Query/Performance Hi list, I'm struggling with a query. We have

[basex-talk] Help with a Query/Performance

2020-01-20 Thread Tom Rauchenwald (UNIFITS)
Hi list, I'm struggling with a query. We have XML documents with a structure similar to this: FOO FOO FOO FOO FOO FOO FOO FOO FOO FOO FOO FOO FOO