BaseX-Talk

basex-talk@mailman.uni-konstanz.de

4 participants
5268 discussions

Basex huge performance hit in linux (Basex query execution is too slow in linux)
by Nikhil Sethi 17 Aug '20

17 Aug '20

Hi Basex Team, We are facing a huge performance hit in linux machine while using basex, its working smoothly in windows machine While executing any query : -> windows machine takes around 4 to 15 millisec -> On linux machine same query takes around 120 to 150 millisec During some application operation execution we are selecting/inserting the xml nodes in different docs in basex and there are around 13000 xml nodes which needs to be selected/imported in this operation. Linux => rhel or cents of Based on the logs of query execution we have analysed and found : Windows worst case(15 ms) query execution time => 13000 x 15ms => 65000ms => 65 sec = around 1 min Linux average case(130 ms(120+150)/2) query execution time => 13000 x 130ms => 1690000ms => 1690 sec = around 28 min to execute same operation we are using BaseX941.zip ZIP Package eg queries : for $alias in collection(mydbname)//* where (($alias/@id="4249f0807da81000a734525400c54430018") and ($alias/@deleted="false") and ($alias/object-type/@uid="com.MyObjectName")) return $alias or insert node <myxmlNode>…….</myxmlNode> into (for $alias in doc('MyDoc') return $alias) I am using basex with java code to get the result System.setProperty("user.home", db_dir); BaseXXQDataSource ds = new BaseXXQDataSource(); ds.setProperty("serverName", "localhost"); ds.setProperty("port", "1984"); ds.setProperty("databaseName", "mydbname"); XQConnection2 connection = (XQConnection2) ds.getConnection("admin", "myDbPassword"); XQStaticContext xqsc = connection.getStaticContext(); xqsc.setScrollability(XQConstants.SCROLLTYPE_SCROLLABLE); connection.setStaticContext(xqsc); XQPreparedExpression expr = connection.prepareExpression(query); XQResultSequence result = expr.executeQuery(); XQSequence scrollableCopy = connection.createSequence(result); getting result from the xqsequnce for 13000 queries is taking another 10 mins Node node = scrollableCopy.getNode() we have tried to increase xms and xmx in basexserver but it didn't help, Can you please suggest any solution/configuration required for linux machine to increase the performance. Thanks, Nikhil

2 5

In search for "basexgui.vbs"
by Andreas Mixich 12 Aug '20

12 Aug '20

Hi, I had a file "basexgui.vbs", which would start the BaseX GUI without opening a console, but upon last installation it got overwritten. I do not find it, neither here, in the list, nor with Google, overall. Does anybody have this? Thanks! -- Minden jót, all the best, Alles Gute, Andreas Mixich

2 2

RESTXQ path resolution
by Ben Pracht 31 Jul '20

31 Jul '20

Hi, I'm trying to resolve a 404 with a RESTXQ service, and got to wondering if it's possible to show the directories it's looking for things, ideally fully qualified paths. Is it possible to turn on logging so much that it shows all the XQ files it found, then show the ones it actually matched? In my case, I put the hello-world service in the main project directory, in the modules directory where the RESTXQPATH and in the RESTPATH. I've tried renaming the hello-world to .xq, .xqm and .xqy. In all cases, it does not find the .xq file. Best Regards, Ben Pracht 919.809.2439 ben.pracht(a)gmail.com

2 3

Feature Request: Save untitled, open scripts when exiting GUI
by Andreas Mixich 30 Jul '20

30 Jul '20

SublimeText has this nifty feature, that it saves all open tabs, even if the have no representation on the filesystem, so one can continue exactly, where one has left off. I find myself often to have several, unnamed, XQueries open, to test this concept, to compose that function, etc. It would be nice, if one could simply shut off and have them reopened next time without naming a file and saving each item in question. -- Minden jót, all the best, Alles Gute, Andreas Mixich

2 6

BaseX 9.4 - XQuery locks - documentation query
by James Ball 30 Jul '20

30 Jul '20

Hello, I was just looking at the changes to locking for 9.4 and I think the documentation has got ‘garbled’ in an update. https://docs.basex.org/wiki/Transaction_Management#XQuery_Locks <https://docs.basex.org/wiki/Transaction_Management#XQuery_Locks> " The lock may be transformed to a write lock by cominthe operations as Similar to the internal database locks, write locks block all other operations while read locks allow parallel access. “ I think this line should be two bullets but I’m not sure what ‘cominthe operations’ should be? Combining? The lock may be transformed to a write lock by combining operations Similar to the internal database locks, write locks block all other operations while read locks allow parallel access. I’m happy to update the wiki but I wasn't confident enough that I’ve understood the 9.4 change to do it without first checking on the list. Regards, James

3 5

Testing if a database exists and if some files exist
by Ramzi Hammouda 29 Jul '20

29 Jul '20

Hello BaseX team, I'm building a C# application, I'm using Rest APIs, how can I test if a database exists or not when I launch my application, and create necessary db/files when they are missing ? Thanks, Ramzi P Respectons ensemble l'environnement. N'imprimez ce message que si n?cessaire. Let's respect the environment together. Only print this message if necessary.

2 1

Reg : Memory leak suspect
by chandra sekhar n 29 Jul '20

29 Jul '20

Dear Basex Team, Basex server instance consuming more money,That instance is not releasing the memory ,to resolve this issue every time we are doing manually stopping the basex server instance and again starting. We are using the Basex7.9 version. We found the leak suspect.Please find in below 986,394,064 bytes (41.11 %) of Java heap is used by 4,062,161 instances of org/basex/query/path/IterStep$1 480,109,832 bytes (20.01 %) of Java heap is used by 100,000 instances of org/basex/query/value/node/FElem 206,334,096 bytes (8.6 %) of Java heap is used by 633,122 instances of org/basex/query/iter/NodeSeqBuilder 178,523,080 bytes (7.44 %) of Java heap is used by 37,245 instances of org/basex/query/value/node/FElem 103,703,288 bytes (4.32 %) of Java heap is used by 1,069,602 instances of org/basex/query/value/node/DBNode What may be causing this problem and what are some possible solutions? Regards, Chandrasekhar

2 4

Inserting a two double quoted attribute
by Ramzi Hammouda 27 Jul '20

27 Jul '20

Hello BaseX team, I need to insert a node that has an attribute with two double quotes. An example: let $message:='<Amt Ccy=""GBP"">3.00</Amt>' return insert nodes fn:parse-xml-fragment($message) as last into doc('testingdb/testing.xml') The GBP attribute is with two " so it gives the error: SAX: file://C:/Program$20Files(86)/BaseX/(Line1)<file:///C:/Program$20Files(86)/BaseX/(Line1)>: whitespace expected, attribute name found. How can I solve the issue? P Respectons ensemble l'environnement. N'imprimez ce message que si n?cessaire. Let's respect the environment together. Only print this message if necessary.

3 2

Re: [basex-talk] [EXTERNAL] - confirm 923b1d852800938568719405edbd581304f2caea
by Srikumar Choudhury 27 Jul '20

27 Jul '20

Hi, <!DOCTYPE some name SYSTEM .. and <?xml version="1.0"?> data loss are happening while importing the xml document using db:replace(...) API. <?xml version="1.0"?> <!DOCTYPE testSuiteConfig SYSTEM "../../../configs/TestConfig_2_1.dtd"> etc. We need help to resolve this issue. we are using Java executeQuery api of XQExpression. class to run "db:replace(...)" query. Please help us, how we can resolve this issue. Thanks, Srikumar ________________________________ From: BaseX-Talk <basex-talk-bounces(a)mailman.uni-konstanz.de> on behalf of basex-talk-request(a)mailman.uni-konstanz.de <basex-talk-request(a)mailman.uni-konstanz.de> Sent: Monday, July 27, 2020 10:54 AM To: Srikumar Choudhury <schoudhu(a)opentext.com> Subject: [EXTERNAL] - confirm 923b1d852800938568719405edbd581304f2caea Mailing list subscription confirmation notice for mailing list BaseX-Talk We have received a request from 49.207.207.45 for subscription of your email address, "schoudhu(a)opentext.com", to the basex-talk(a)mailman.uni-konstanz.de mailing list. To confirm that you want to be added to this mailing list, simply reply to this message, keeping the Subject: header intact. Or visit this web page: https://urldefense.com/v3/__https://mailman.uni-konstanz.de/mailman/confirm… Or include the following line -- and only the following line -- in a message to basex-talk-request(a)mailman.uni-konstanz.de: confirm 923b1d852800938568719405edbd581304f2caea Note that simply sending a `reply' to this message should work from most mail readers, since that usually leaves the Subject: line in the right form (additional "Re:" text in the Subject: is okay). If you do not wish to be subscribed to this list, please simply disregard this message. If you think you are being maliciously subscribed to the list, or have any other questions, send them to basex-talk-owner(a)mailman.uni-konstanz.de.

1 0

Memoize
by Mickael Desfrenes 25 Jul '20

25 Jul '20

Hello dear basex list, Is there any known solution for function memoization in basex ? Or maybe a cache implementation ? M. Desfrênes

4 9

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk