BaseX-Talk

basex-talk@mailman.uni-konstanz.de

5 participants
5249 discussions

Duplicate files when using webDAV and batch processes
by France Baril 25 May '18

25 May '18

Hi, We've been having this issue for a while and we think resolving it may be the key to resolving an intermittent server 500 error that we've been having. When a user tries to save a file while a batch process is running, BaseX saves duplicates of the file. How to reproduce: 1) Take a fresh BaseX 9.0.1 installation 2) Copy the attached .xqm in webapp 3) Create an empty DB called mydb 4) Access localhost:port-num/test/create-update-a-lot-of-files to populate your db. 5) In OxygenXML, set a webdav connection to the db and open a file, add a character in one of the elements, but don't save the file. 6) From the browser, access 'localhost:port-num/test/update-something' 7) While the process in the browser is still running, save the file in Oxygen. You'll get a message saying that read timed out. Click ok and do not try saving the file again. 8) When the update-something process is done running, don't resave the file in Oxygen, instead go to localhost:port-num/test/oups-duplicates. You'll get a message saying that some files are duplicated. If you don't try again from step #4 a few times. You'll only get duplicates if you get the time out message before the update-something process is still running. If you try to save the file many times, you'll get more duplicates, 4 or 6. We're not sure if it's a BaseX bug or if we are setting our user management and/or locking rules incorrectly. Do you have any suggestions? -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

2 10

Re: [basex-talk] basex trouble
by Christian Grün 24 May '18

24 May '18

Hi Ветошкин (cc to the list), Maybe we find a way to speed up your queries; you can attach them to your next mail. I guess that the parallel query execution leads to "random access patterns" on disk. You can enforce one query at a time by setting the PARALLEL option to 1 (see [1]). Hope this helps, Christian [1] http://docs.basex.org/wiki/Options#PARALLEL On Wed, May 23, 2018 at 9:40 PM, Ветошкин Владимир <en-trance(a)yandex.ru> wrote: > Hi, Christian! > > Thank you. > > I have two scripts, which make queries to one database. > If I run these queries at different times, each of them completes in about 5 > sec. > But if I run both scripts at one time, it takes about 40 sec. > > If the scripts make queries to different databases - it's ok, it takes about > 5 sec. > > Is it possible to improve this situation? > > I tried to use this code to load database in main-memory: > db:open('db1') update {} > But it didn't help. > > I hope, you understand me :) > > > 23.05.2018, 20:15, "Christian Grün" <christian.gruen(a)gmail.com>: > > Привет Ветошкин, > > Welcome to the list. Just send your question to this address. > > Best, > Christian > > > > Ветошкин Владимир <en-trance(a)yandex.ru> schrieb am Mi., 23. Mai 2018, 19:10: > > Hello! > > Sorry for my English. > May I ask you some questions here or I have to write them on github? > > -- > С уважением, > Ветошкин Владимир Владимирович > > > > -- > С уважением, > Ветошкин Владимир Владимирович >

2 5

Atomization
by Giuseppe Celano 24 May '18

24 May '18

I think I have identified a problem with atomization of attribute content (no database involved). I have a simple query: for $s in doc("doc1")//s//t for $d in doc("doc2")//case where $d/verb_lemma = $s/@l and $d//verb_form/@value = $s/@f and $d/aspect-values/@sign = "yes" return $s In order to get a result, I (necessarily) need to use the data() function in data($d/aspect-values/@sign) = "yes", otherwise the query never returns a result. Is this a bug? I would expect that the value of @sign is automatically atomized and compared to "yes", but this does not seem the case. Thanks. Ciao, Giuseppe Universität Leipzig Institute of Computer Science, NLP Augustusplatz 10 04109 Leipzig Deutschland E-mail: celano(a)informatik.uni-leipzig.de E-mail: giuseppegacelano(a)gmail.com Web site 1: http://www.dh.uni-leipzig.de/wo/team/ Web site 2: https://sites.google.com/site/giuseppegacelano/

2 3

basex trouble
by Ветошкин Владимир 23 May '18

23 May '18

Hello! Sorry for my English. May I ask you some questions here or I have to write them on github? -- С уважением, Ветошкин Владимир Владимирович

2 1

New BaseX setup
by France Baril 23 May '18

23 May '18

Hi, In one of my projects, we are trying to refactor our code so it uses a node.js client. We have extensive functions that do more than just get data in our .xqm. They were implemented around the http server and our web application was calling the REST functions we implemented using jquery AJAX request. All the examples we looked at in the documentation that don't use the http server pass entire queries as a string to the server. We were wondering if we can call functions from our .xqm modules directly (ex. namespace:do-this(param0, param1)) or if any request that uses functions from our .xqm files need to pass through the rest API. If we can call our .xqm functions more directly, could you point us to an example to help us understand how it would work? Thanks! -- France Baril Architecte documentaire / Documentation architect france.baril(a)architextus.com

4 4

(no subject)
by Kirsten, Dirk 23 May '18

23 May '18

Dear list, I tried to insert a huge XML document (english wikipedia). When doing so and using the default parser I got the following warning: "/my/path/enwiki-latest-pages-articles.xml" (Line 61696838): JAXP00010004: The accumulated size of entities is "50,000,001" that exceeded the "50,000,000" limit set by "FEATURE_SECURE_PROCESSING". I solved this by setting the environment variables: -DentityExpansionLimit=2147480000 -DtotalEntitySizeLimit=2147480000 -Djdk.xml.totalEntitySizeLimit=2147480000 So it seems this is a security measure from JXB. Would it be possible to set these values by default or at least be able to change the limit with the GUI or BaseX options? Cheers Dirk Dirk Kirsten ______________________________ Senacor Technologies AG D?sseldorfer Stra?e 13 65760 Eschborn M +49 (151) 4435 1967 Dirk.Kirsten(a)senacor.com www.senacor.com Senacor Technologies Aktiengesellschaft - Sitz: Eschborn - Amtsgericht Frankfurt am Main - Reg.-Nr.: HRB 105546 Vorstand: Matthias Tomann, Marcus Purzer - Aufsichtsratsvorsitzender: Daniel Gr?zinger Diese E-Mail inklusive Anlagen enth?lt vertrauliche und/oder rechtlich gesch?tzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrt?mlich erhalten, informieren Sie bitte den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet. This e-mail including any attachments may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the materials in this e-mail is strictly forbidden.

2 1

Re: [basex-talk] BaseX-Talk Digest, Vol 101, Issue 37
by Kristian Kankainen 22 May '18

22 May '18

I have a setup using rsync to keep database directory copies synchronized with a master over the network. It works very well for me.22. mai 2018 10:16 kirjutas kuupäeval Alexander Holupirek <alex(a)holupirek.de>: > > Hi Martin, > > export/import is one option. backup/restore another [1]. > And a third could be to copy the database directory (provided the servers have a more or less similar setup). > > Cheers, > Alex > > [1] http://docs.basex.org/wiki/Backups (can also be done via DBA [2]) > [2] http://docs.basex.org/wiki/DBA > > > On 21. May 2018, at 18:32, Martin Lourduswamy <martin.louis(a)gmail.com> wrote: > > > > Hi, > > I would like to know how to copy a database from one server to another server, please let me know. > > Is it export and get and load xml or is there another way to do it, thanks for the clarification, > > Regards > > Martin Lourduswamy > > > > On Mon, May 21, 2018 at 6:00 AM, <basex-talk-request(a)mailman.uni-konstanz.de> wrote: > > Send BaseX-Talk mailing list submissions to > > basex-talk(a)mailman.uni-konstanz.de > > > > To subscribe or unsubscribe via the World Wide Web, visit > > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk > > or, via email, send a message with subject or body 'help' to > > basex-talk-request(a)mailman.uni-konstanz.de > > > > You can reach the person managing the list at > > basex-talk-owner(a)mailman.uni-konstanz.de > > > > When replying, please edit your Subject line so it is more specific > > than "Re: Contents of BaseX-Talk digest..." > > > > > > Today's Topics: > > > > 1. Fwd: BaseX performance improvements (Christian Gr?n) > > 2. Re: BaseX performance improvements (Christian Gr?n) > > > > > > ---------------------------------------------------------------------- > > > > Message: 1 > > Date: Sun, 20 May 2018 18:51:03 +0200 > > From: Christian Gr?n <christian.gruen(a)gmail.com> > > To: Martin Lourduswamy <martin.louis(a)gmail.com>, BaseX > > <basex-talk(a)mailman.uni-konstanz.de> > > Subject: [basex-talk] Fwd: BaseX performance improvements > > Message-ID: > > <CAP94bnPHW=NqzXxY-cfubGSLzWLoiiPzj_WfNj6tWYZFg0DtJA(a)mail.gmail.com> > > Content-Type: text/plain; charset="UTF-8" > > > > Hi Martin (cc to the list), > > > > > 1. each XML node => 500 bytes > > > 2. total size of XML DB => 10million nodes(which will grow continuously as > > > new files are added). > > > > So one node is one document, right? I?m just asking because, in the > > XML terminology, each XML document has nodes itself: element nodes, > > attributes nodes, text nodes, etc. > > > > If you are working with millions of documents, it can be helpful to > > work with a "daily" database, which contains auxiliary references on > > documents that have been deleted or updated. If there is a time > > interval in which no people access your database (e.g. each night), > > you can merge these databases and recreate your index structures. If > > you query your database, you can a few more lines of XQuery: first > > check your daily database, and (if it doesn?t contain the required > > document) look up the document in your fully indexed database. > > > > > I have to do a update of the nodes as I need to replace them. I chose delete > > > + insert instead of replace > > > > Please note that a replace operation can be much faster: If the > > structure of the updated document is similar to the old document, the > > document can be replace in-place. > > > > > Also, I am thinking of indexing on the node id, as that is like the primary > > > key on which I base my operations, any suggestions might also be helpful, > > > > Here it may also be interesting to know if you will only address > > documents or arbitrary nodes of your document. In the first case, > > addressing the document path via db:open should be sufficient [1]. In > > the latter case, you could possibly use the existing function > > db:node-id [2]. > > > > Hope this helps, > > Christian > > > > [1] http://docs.basex.org/wiki/Databases > > [2] http://docs.basex.org/wiki/Database_Module#db:node-id > > > > > > > > > Thanks again, > > > Regards > > > Martin Lourduswamy > > > > > > On Sun, May 20, 2018 at 9:28 AM, Christian Gr?n <christian.gruen(a)gmail.com> > > > wrote: > > >> > > >> Hi Martin, > > >> > > >> > I am new to BaseX, I would like ot speed up XQuery of insert and delete > > >> > and > > >> > replace through options. > > >> > > >> Welcome to the list. As there are numerous ways to do updates in > > >> BaseX, feel free to give us more information on your insert and delete > > >> operations. Do you work with large single documents or many small > > >> documents? How large is your database? > > >> > > >> > While I query basex through perl, and try to > > >> > connect through GUI, the perl connection aborts. Is there a parameters > > >> > for > > >> > parallel connections, please let me know. > > >> > > >> I can?t tell why your perl connection is interrupted by opening the > > >> GUI (because they should be completely independent from each other). A > > >> step-by-step description on how you proceeded might be helpful. > > >> > > >> Because there is no coupling between GUI and the client/server > > >> architecture, however, you should avoid running updates outside the > > >> GUI. Please check out [1] for more information. > > >> > > >> Best, > > >> Christian > > >> > > >> [1] http://docs.basex.org/wiki/Startup#Concurrent_Operations > > >> > > >> > > >> > > >> > > > >> > Thanks, > > >> > Regards > > >> > Martin Lourduswamy > > > > > > > > > > > > ------------------------------ > > > > Message: 2 > > Date: Sun, 20 May 2018 18:56:45 +0200 > > From: Christian Gr?n <christian.gruen(a)gmail.com> > > To: Martin Lourduswamy <martin.louis(a)gmail.com>, BaseX > > <basex-talk(a)mailman.uni-konstanz.de> > > Subject: Re: [basex-talk] BaseX performance improvements > > Message-ID: > > <CAP94bnN6w7ZaaNu43AqdzrKYsaqaxKGSamRNP8zy3fmEEJZ6Hg(a)mail.gmail.com> > > Content-Type: text/plain; charset="UTF-8" > > > > > Java heap space at C:\Users\lourduswamym\oracle_scripts/BaseXClient.pm line > > > 213. > > > > How much memory have you assigned to BaseX [1]? > > > > > Actually the error on the server log. The insert operation was taking 1+minutes due to slow network and then the error happened. I have been running this server instance continuously for 1 day with continuous insert from a per script. > > > > If you create a new database, you can specify a directory with the > > files that are to be initially added to your database. This might save > > you a lot of time. > > > > > So I think I should be careful to run only one single process of client at a > > > time or make sure memory is enough to handle multiple client operations, > > > please let me know your thoughts, > > > > If your documents are small, you shouldn?t usually encounter any > > errors. But it might have to do with the large number of documents you > > are dealing with. One more option is to distribute your docs across > > multiple databases (you can access all of them via a single XQuery > > expression). > > > > Best, > > Christian > > > > [1] http://docs.basex.org/wiki/Start_Scripts > > > > > > > > > > > Thanks again, > > > Regards > > > Martin Lourduswamy > > > > > > On Sun, May 20, 2018 at 9:48 AM, Martin Lourduswamy <martin.louis(a)gmail.com> > > > wrote: > > >> > > >> Hi, > > >> > > >> Thanks for the clarifications. My database is > > >> > > >> DB Size: > > >> ====== > > >> 1. each XML node => 500 bytes > > >> 2. total size of XML DB => 10million nodes(which will grow continuously as > > >> new files are added). > > >> 3. I will be having multiple DB's of same size and more size as the DB > > >> continuously grows > > >> > > >> I have to do a update of the nodes as I need to replace them. I chose > > >> delete + insert instead of replace for each of the node through perl, as I > > >> will make sure there are no duplicate nodes left in the database.(just a > > >> precaution that even if some nodes get duplicated, through some other > > >> processes I will be able to remove them by delete) > > >> > > >> DB Speed: > > >> ======== > > >> I will disable logging as it might speed up the database operations. > > >> > > >> DB Architecture > > >> ============ > > >> 1 server(windows or Linux) running baseX > > >> multiple client computers trying to query the same machine for select > > >> through fn:doc(...) API to get the data through perl > > >> then do a delete + insert from perl > > >> > > >> I would like to know if you think this might work for production and any > > >> suggestion for data retrieval and update > > >> Any changes to the way I architecture it might help > > >> > > >> Also, I am thinking of indexing on the node id, as that is like the > > >> primary key on which I base my operations, any suggestions might also be > > >> helpful, > > >> Thanks again, > > >> Regards > > >> Martin Lourduswamy > > >> > > >> On Sun, May 20, 2018 at 9:28 AM, Christian Gr?n > > >> <christian.gruen(a)gmail.com> wrote: > > >>> > > >>> Hi Martin, > > >>> > > >>> > I am new to BaseX, I would like ot speed up XQuery of insert and delete > > >>> > and > > >>> > replace through options. > > >>> > > >>> Welcome to the list. As there are numerous ways to do updates in > > >>> BaseX, feel free to give us more information on your insert and delete > > >>> operations. Do you work with large single documents or many small > > >>> documents? How large is your database? > > >>> > > >>> > While I query basex through perl, and try to > > >>> > connect through GUI, the perl connection aborts. Is there a parameters > > >>> > for > > >>> > parallel connections, please let me know. > > >>> > > >>> I can?t tell why your perl connection is interrupted by opening the > > >>> GUI (because they should be completely independent from each other). A > > >>> step-by-step description on how you proceeded might be helpful. > > >>> > > >>> Because there is no coupling between GUI and the client/server > > >>> architecture, however, you should avoid running updates outside the > > >>> GUI. Please check out [1] for more information. > > >>> > > >>> Best, > > >>> Christian > > >>> > > >>> [1] http://docs.basex.org/wiki/Startup#Concurrent_Operations > > >>> > > >>> > > >>> > > >>> > > > >>> > Thanks, > > >>> > Regards > > >>> > Martin Lourduswamy > > >> > > >> > > > > > > > > > End of BaseX-Talk Digest, Vol 101, Issue 37 > > ******************************************* > > >

1 0

Re: [basex-talk] BaseX-Talk Digest, Vol 101, Issue 37
by Martin Lourduswamy 22 May '18

22 May '18

Hi, I would like to know how to copy a database from one server to another server, please let me know. Is it export and get and load xml or is there another way to do it, thanks for the clarification, Regards Martin Lourduswamy On Mon, May 21, 2018 at 6:00 AM, <basex-talk-request(a)mailman.uni-konstanz.de > wrote: > Send BaseX-Talk mailing list submissions to > basex-talk(a)mailman.uni-konstanz.de > > To subscribe or unsubscribe via the World Wide Web, visit > https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk > or, via email, send a message with subject or body 'help' to > basex-talk-request(a)mailman.uni-konstanz.de > > You can reach the person managing the list at > basex-talk-owner(a)mailman.uni-konstanz.de > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of BaseX-Talk digest..." > > > Today's Topics: > > 1. Fwd: BaseX performance improvements (Christian Gr?n) > 2. Re: BaseX performance improvements (Christian Gr?n) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sun, 20 May 2018 18:51:03 +0200 > From: Christian Gr?n <christian.gruen(a)gmail.com> > To: Martin Lourduswamy <martin.louis(a)gmail.com>, BaseX > <basex-talk(a)mailman.uni-konstanz.de> > Subject: [basex-talk] Fwd: BaseX performance improvements > Message-ID: > <CAP94bnPHW=NqzXxY-cfubGSLzWLoiiPzj_WfNj6tWYZFg0DtJA(a)mail.gmail. > com> > Content-Type: text/plain; charset="UTF-8" > > Hi Martin (cc to the list), > > > 1. each XML node => 500 bytes > > 2. total size of XML DB => 10million nodes(which will grow continuously > as > > new files are added). > > So one node is one document, right? I?m just asking because, in the > XML terminology, each XML document has nodes itself: element nodes, > attributes nodes, text nodes, etc. > > If you are working with millions of documents, it can be helpful to > work with a "daily" database, which contains auxiliary references on > documents that have been deleted or updated. If there is a time > interval in which no people access your database (e.g. each night), > you can merge these databases and recreate your index structures. If > you query your database, you can a few more lines of XQuery: first > check your daily database, and (if it doesn?t contain the required > document) look up the document in your fully indexed database. > > > I have to do a update of the nodes as I need to replace them. I chose > delete > > + insert instead of replace > > Please note that a replace operation can be much faster: If the > structure of the updated document is similar to the old document, the > document can be replace in-place. > > > Also, I am thinking of indexing on the node id, as that is like the > primary > > key on which I base my operations, any suggestions might also be helpful, > > Here it may also be interesting to know if you will only address > documents or arbitrary nodes of your document. In the first case, > addressing the document path via db:open should be sufficient [1]. In > the latter case, you could possibly use the existing function > db:node-id [2]. > > Hope this helps, > Christian > > [1] http://docs.basex.org/wiki/Databases > [2] http://docs.basex.org/wiki/Database_Module#db:node-id > > > > > Thanks again, > > Regards > > Martin Lourduswamy > > > > On Sun, May 20, 2018 at 9:28 AM, Christian Gr?n < > christian.gruen(a)gmail.com> > > wrote: > >> > >> Hi Martin, > >> > >> > I am new to BaseX, I would like ot speed up XQuery of insert and > delete > >> > and > >> > replace through options. > >> > >> Welcome to the list. As there are numerous ways to do updates in > >> BaseX, feel free to give us more information on your insert and delete > >> operations. Do you work with large single documents or many small > >> documents? How large is your database? > >> > >> > While I query basex through perl, and try to > >> > connect through GUI, the perl connection aborts. Is there a parameters > >> > for > >> > parallel connections, please let me know. > >> > >> I can?t tell why your perl connection is interrupted by opening the > >> GUI (because they should be completely independent from each other). A > >> step-by-step description on how you proceeded might be helpful. > >> > >> Because there is no coupling between GUI and the client/server > >> architecture, however, you should avoid running updates outside the > >> GUI. Please check out [1] for more information. > >> > >> Best, > >> Christian > >> > >> [1] http://docs.basex.org/wiki/Startup#Concurrent_Operations > >> > >> > >> > >> > > >> > Thanks, > >> > Regards > >> > Martin Lourduswamy > > > > > > > ------------------------------ > > Message: 2 > Date: Sun, 20 May 2018 18:56:45 +0200 > From: Christian Gr?n <christian.gruen(a)gmail.com> > To: Martin Lourduswamy <martin.louis(a)gmail.com>, BaseX > <basex-talk(a)mailman.uni-konstanz.de> > Subject: Re: [basex-talk] BaseX performance improvements > Message-ID: > <CAP94bnN6w7ZaaNu43AqdzrKYsaqaxKGSamRNP8zy3fmEEJZ6Hg@mail. > gmail.com> > Content-Type: text/plain; charset="UTF-8" > > > Java heap space at C:\Users\lourduswamym\oracle_scripts/BaseXClient.pm > line > > 213. > > How much memory have you assigned to BaseX [1]? > > > Actually the error on the server log. The insert operation was taking > 1+minutes due to slow network and then the error happened. I have been > running this server instance continuously for 1 day with continuous insert > from a per script. > > If you create a new database, you can specify a directory with the > files that are to be initially added to your database. This might save > you a lot of time. > > > So I think I should be careful to run only one single process of client > at a > > time or make sure memory is enough to handle multiple client operations, > > please let me know your thoughts, > > If your documents are small, you shouldn?t usually encounter any > errors. But it might have to do with the large number of documents you > are dealing with. One more option is to distribute your docs across > multiple databases (you can access all of them via a single XQuery > expression). > > Best, > Christian > > [1] http://docs.basex.org/wiki/Start_Scripts > > > > > > Thanks again, > > Regards > > Martin Lourduswamy > > > > On Sun, May 20, 2018 at 9:48 AM, Martin Lourduswamy < > martin.louis(a)gmail.com> > > wrote: > >> > >> Hi, > >> > >> Thanks for the clarifications. My database is > >> > >> DB Size: > >> ====== > >> 1. each XML node => 500 bytes > >> 2. total size of XML DB => 10million nodes(which will grow continuously > as > >> new files are added). > >> 3. I will be having multiple DB's of same size and more size as the DB > >> continuously grows > >> > >> I have to do a update of the nodes as I need to replace them. I chose > >> delete + insert instead of replace for each of the node through perl, > as I > >> will make sure there are no duplicate nodes left in the database.(just a > >> precaution that even if some nodes get duplicated, through some other > >> processes I will be able to remove them by delete) > >> > >> DB Speed: > >> ======== > >> I will disable logging as it might speed up the database operations. > >> > >> DB Architecture > >> ============ > >> 1 server(windows or Linux) running baseX > >> multiple client computers trying to query the same machine for select > >> through fn:doc(...) API to get the data through perl > >> then do a delete + insert from perl > >> > >> I would like to know if you think this might work for production and any > >> suggestion for data retrieval and update > >> Any changes to the way I architecture it might help > >> > >> Also, I am thinking of indexing on the node id, as that is like the > >> primary key on which I base my operations, any suggestions might also be > >> helpful, > >> Thanks again, > >> Regards > >> Martin Lourduswamy > >> > >> On Sun, May 20, 2018 at 9:28 AM, Christian Gr?n > >> <christian.gruen(a)gmail.com> wrote: > >>> > >>> Hi Martin, > >>> > >>> > I am new to BaseX, I would like ot speed up XQuery of insert and > delete > >>> > and > >>> > replace through options. > >>> > >>> Welcome to the list. As there are numerous ways to do updates in > >>> BaseX, feel free to give us more information on your insert and delete > >>> operations. Do you work with large single documents or many small > >>> documents? How large is your database? > >>> > >>> > While I query basex through perl, and try to > >>> > connect through GUI, the perl connection aborts. Is there a > parameters > >>> > for > >>> > parallel connections, please let me know. > >>> > >>> I can?t tell why your perl connection is interrupted by opening the > >>> GUI (because they should be completely independent from each other). A > >>> step-by-step description on how you proceeded might be helpful. > >>> > >>> Because there is no coupling between GUI and the client/server > >>> architecture, however, you should avoid running updates outside the > >>> GUI. Please check out [1] for more information. > >>> > >>> Best, > >>> Christian > >>> > >>> [1] http://docs.basex.org/wiki/Startup#Concurrent_Operations > >>> > >>> > >>> > >>> > > >>> > Thanks, > >>> > Regards > >>> > Martin Lourduswamy > >> > >> > > > > > End of BaseX-Talk Digest, Vol 101, Issue 37 > ******************************************* >

2 1

about special characters
by BitRider001 22 May '18

22 May '18

Hi, I just joined the mailing list due to a problem I'm having displaying and storing special characters. I started with a CSV and created a database from it and the CSV is in UTF-8. However, when I query the special characters become garbled. I'm using the GUI in Windows 10. It starts with this in the CSV: <name>Cañelas</name> Then ends up with this when I export the query result into a text file: <name>ï£¼Caï¿½ï£¼las</name> Help please. Bit

5 10

Re: [basex-talk] BaseX performance improvements
by Christian Grün 20 May '18

20 May '18

> Java heap space at C:\Users\lourduswamym\oracle_scripts/BaseXClient.pm line > 213. How much memory have you assigned to BaseX [1]? > Actually the error on the server log. The insert operation was taking 1+minutes due to slow network and then the error happened. I have been running this server instance continuously for 1 day with continuous insert from a per script. If you create a new database, you can specify a directory with the files that are to be initially added to your database. This might save you a lot of time. > So I think I should be careful to run only one single process of client at a > time or make sure memory is enough to handle multiple client operations, > please let me know your thoughts, If your documents are small, you shouldn’t usually encounter any errors. But it might have to do with the large number of documents you are dealing with. One more option is to distribute your docs across multiple databases (you can access all of them via a single XQuery expression). Best, Christian [1] http://docs.basex.org/wiki/Start_Scripts > Thanks again, > Regards > Martin Lourduswamy > > On Sun, May 20, 2018 at 9:48 AM, Martin Lourduswamy <martin.louis(a)gmail.com> > wrote: >> >> Hi, >> >> Thanks for the clarifications. My database is >> >> DB Size: >> ====== >> 1. each XML node => 500 bytes >> 2. total size of XML DB => 10million nodes(which will grow continuously as >> new files are added). >> 3. I will be having multiple DB's of same size and more size as the DB >> continuously grows >> >> I have to do a update of the nodes as I need to replace them. I chose >> delete + insert instead of replace for each of the node through perl, as I >> will make sure there are no duplicate nodes left in the database.(just a >> precaution that even if some nodes get duplicated, through some other >> processes I will be able to remove them by delete) >> >> DB Speed: >> ======== >> I will disable logging as it might speed up the database operations. >> >> DB Architecture >> ============ >> 1 server(windows or Linux) running baseX >> multiple client computers trying to query the same machine for select >> through fn:doc(...) API to get the data through perl >> then do a delete + insert from perl >> >> I would like to know if you think this might work for production and any >> suggestion for data retrieval and update >> Any changes to the way I architecture it might help >> >> Also, I am thinking of indexing on the node id, as that is like the >> primary key on which I base my operations, any suggestions might also be >> helpful, >> Thanks again, >> Regards >> Martin Lourduswamy >> >> On Sun, May 20, 2018 at 9:28 AM, Christian Grün >> <christian.gruen(a)gmail.com> wrote: >>> >>> Hi Martin, >>> >>> > I am new to BaseX, I would like ot speed up XQuery of insert and delete >>> > and >>> > replace through options. >>> >>> Welcome to the list. As there are numerous ways to do updates in >>> BaseX, feel free to give us more information on your insert and delete >>> operations. Do you work with large single documents or many small >>> documents? How large is your database? >>> >>> > While I query basex through perl, and try to >>> > connect through GUI, the perl connection aborts. Is there a parameters >>> > for >>> > parallel connections, please let me know. >>> >>> I can’t tell why your perl connection is interrupted by opening the >>> GUI (because they should be completely independent from each other). A >>> step-by-step description on how you proceeded might be helpful. >>> >>> Because there is no coupling between GUI and the client/server >>> architecture, however, you should avoid running updates outside the >>> GUI. Please check out [1] for more information. >>> >>> Best, >>> Christian >>> >>> [1] http://docs.basex.org/wiki/Startup#Concurrent_Operations >>> >>> >>> >>> > >>> > Thanks, >>> > Regards >>> > Martin Lourduswamy >> >> >

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

BaseX-Talk