On Fri, 2020-08-21 at 17:28 -0700, Bill Osmond wrote:
> I'm beginning to think that perhaps my performance hopes were a bit
> too
> inflated, given the size and complexity of our database. After a
> fresh
> optimization, and with -Xms2g -Xmx10g, the following query takes
> 1492ms:
[...]
First
I'm beginning to think that perhaps my performance hopes were a bit too
inflated, given the size and complexity of our database. After a fresh
optimization, and with -Xms2g -Xmx10g, the following query takes 1492ms:
declare namespace ernm="http://ddex.net/xml/ern/411;;
for $r in
Hi André,
Thanks for the observation. I’ve checked our recent releases, and it
seems that the interactive path completion got corrupted with version
9.3 of BaseX. We’ll fix this in our next snapshot and keep you
updated.
Greeting across the border,
Christian
On Fri, Aug 21, 2020 at 10:58 PM
Just a quick hint: As the query info output indicates that no text
index is used (see [1]), you could try to attach explicit text() steps
in your comparisons:
where $track_release/ReleaseLabelReference/text() =
$r/PartyList/Party/PartyReference/text()
...
where
The indentation levels and multiple returns in your suggested query alone
has helped me in understanding what's actually going on, and I've rewritten
the query mostly as you suggest:
for $r in /ernm:NewReleaseMessage
for $track_release in $r/ReleaseList/TrackRelease
where
Hello everyone,
I'm trying to do some simple XPath searches (BaseX GUI 9.4.1) of the kind //name or//someThing/anotherThing/name - using the input bar. In the past, I almost always used the "find" mode and always got what is probably called Xpath suggestions (mentioned on
Thank you both! I was in the middle of typing a response to Bridger when
this came through, so while I digest both of your messages & test index
addition/moving things around, I'll leave the output from the GUI info
panel here - if I knew how to read it, it would no doubt point straight at
the
On Fri, 2020-08-21 at 12:51 -0700, Bill Osmond wrote:
>
> declare namespace ernm="http://ddex.net/xml/ern/411;;
>
> for $r in /ernm:NewReleaseMessage
> for $track_release in $r/ReleaseList/TrackRelease
> for $party in $r/PartyList/Party
> for $sound_recording in
Hi Bill,
I won't claim to be any kind of query expert, but there are some things you
can try to experiment with query speeds:
On Fri, Aug 21, 2020 at 3:52 PM Bill Osmond wrote:
> Hi all,
> I'm attempting to query a fairly large database, with 136,938 resources
> and a size of 12,257,686,099.
Hi all,
I'm attempting to query a fairly large database, with 136,938 resources and
a size of 12,257,686,099. The basex server itself is an AWS EC2 instance
with 4 cores & 16 gigs of ram, using -Xmx12g. The database contains audio
DDEX information which (to me at least) is fairly complicated XML.
I have tried following steps:
C:\Srikumar\Software\BaseX\BaseX941\basex>java -Dorg.basex.DEFAULTDB=true -cp
basex.jar org.basex.BaseX -c"get DEFAULTDB"
DEFAULTDB: true
C:\Srikumar\Software\BaseX\BaseX941\basex>cd bin
C:\Srikumar\Software\BaseX\BaseX941\basex\bin>basex
BaseX 9.4.1 [Standalone]
Hi Christian,
I have tested below code but it is not working.
System.setProperty("org.basex.DEFAULTDB", "true");
XQDataSource xqs = new BaseXXQDataSource();
and xquery is:
String xQuery = "for $article in doc('6301904f8114/0601904f80007547.xml')
return $article";
it is not
Dear all,
We have released another 9.4 late-summer maintenance release with new
performance tweaks and minor bug fixes:
http://basex.org
In addition, we have started a new Wiki article on XQuery
optimizations, which we plan to extend step by step:
> C:\Srikumar\Software\BaseX\BaseX941\basex>java -Dorg.basex.DEFAULTDB=true -cp
> basex.jar org.basex.BaseX -c"get DEFAULTDB"
> DEFAULTDB: true
>
> C:\Srikumar\Software\BaseX\BaseX941\basex\bin>basex
> BaseX 9.4.1 [Standalone]
> Try 'help' to get more information.
…this can’t work, as properties
Let’s stick with one variant:
> What do you get if you run the following XQuery expression?
…in your XQJ code?
>I have tested below code but it is not working.
>
> System.setProperty("org.basex.DEFAULTDB", "true");
> XQDataSource xqs = new BaseXXQDataSource();
What do you get if you run the following XQuery expression?
db:system()//defaultdb
16 matches
Mail list logo