[basex-talk] Question ft:mark()

2018-08-12 Thread Johannes Bauer
Hello, I have a question regarding the usage of the ft:mark() function. Database content: Some text text search text some more text XQuery: { let $search := 'search' for $match at $pos in //*[text() contains text {$search}] let $match_parent := $match/.. return

Re: [basex-talk] Huge CSV

2018-08-12 Thread Giuseppe Celano
Yes, I build them, but I do not use them explicitly all the time. > On Aug 13, 2018, at 12:04 AM, Liam R. E. Quin wrote: > > On Sun, 2018-08-12 at 23:58 +0200, Giuseppe Celano wrote: >> more documents accessed sequentially is better than one >> big file. > > Are you building indexes in the

Re: [basex-talk] Huge CSV

2018-08-12 Thread Liam R. E. Quin
On Sun, 2018-08-12 at 23:58 +0200, Giuseppe Celano wrote: > more documents accessed sequentially is better than one > big file. Are you building indexes in the database? Do yourqueries make use of them? You may find using the full text extensions useful. Liam -- Liam Quin,

Re: [basex-talk] Huge CSV

2018-08-12 Thread Giuseppe Celano
Hi Liam, Thanks for answering. The problem is not only the XML transformation per se, but also the subsequent query of the documents. I see that if I parcel the big csv into smaller (XML) documents and query them sequentially, I have no performance problems. This is also the case in the