Re: [basex-talk] basex trouble

2018-05-24 Thread Ветошкин Владимир
ccess > 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-tra...@yan

Re: [basex-talk] basex trouble

2018-05-24 Thread Ветошкин Владимир
Christian, Is it possible to add index only for "EnvelopeID" since only this field is in where clause? May be it will speed up the queries.. 24.05.2018, 14:47, "Ветошкин Владимир" <en-tra...@yandex.ru>: > Thank you Christian for your kind words :) > > I rewro

[basex-talk] basex trouble

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

[basex-talk] progress of query execution

2018-05-27 Thread Ветошкин Владимир
execution of query? -- С уважением, Ветошкин Владимир Владимирович

Re: [basex-talk] Full-Text

2018-06-25 Thread Ветошкин Владимир
return db:open($i)return $docs/* On Mon, Jun 25, 2018 at 12:32 PM Ветошкин Владимир <en-tra...@yandex.ru> wrote:Hi, Alexander, Some questions:After that, how can I perform a search in all of these databases?Can I search for substring without fulltext using only text index? 25.06.2018, 11:56, "Al

Re: [basex-talk] Full-Text

2018-06-25 Thread Ветошкин Владимир
u can also specify a list of element or attribute names to be indexed, and by the way reduce the time needed to reindex. Best regards,Fabrice De : Ветошкин Владимир [mailto:en-tra...@yandex.ru]Envoyé : lundi 25 juin 2018 09:42À : Fabrice ETANCHAUD; BaseXObjet : Re: [basex-talk] Full-Text Hi, Fabrice

Re: [basex-talk] Full-Text

2018-06-25 Thread Ветошкин Владимир
.   On Mon, Jun 25, 2018 at 10:42 AM Ветошкин Владимир <en-tra...@yandex.ru> wrote:Hi, Fabrice!Thank you. All databases constantly change.That is why there is no way to single out "a big readonly collection" :(Maybe it is possible to use some other incremental indexes?I have t

Re: [basex-talk] Full-Text

2018-06-25 Thread Ветошкин Владимир
the full-text index is deleted.After importing I recreate whole full-text index and it takes too much time :( -- С уважением,Ветошкин Владимир Владимирович   -- С уважением,Ветошкин Владимир Владимирович 

Re: [basex-talk] Full-Text

2018-06-25 Thread Ветошкин Владимир
even every month.  On Mon, Jun 25, 2018 at 11:50 AM Ветошкин Владимир <en-tra...@yandex.ru> wrote:Hi, Alexander!Thank you! In my previous letter I have described the proccess in short.I'll think about separated DB. But I'm afraid that this base will also be very big in future.Although I can t

[basex-talk] Full-Text

2018-06-21 Thread Ветошкин Владимир
Hi, everyone! Is there any way to index only imported xml-files?Now, when I import xml-files the full-text index is deleted.After importing I recreate whole full-text index and it takes too much time :( -- С уважением,Ветошкин Владимир Владимирович 

[basex-talk] release read lock

2018-08-16 Thread Ветошкин Владимир
Hi! Is there a way to cache data and release read lock ?I have to get some data from DB and then make some actions with it, that takes a long time. I would like to release lock after getting data from the DB. -- С уважением,Ветошкин Владимир Владимирович 

Re: [basex-talk] release read lock

2018-08-17 Thread Ветошкин Владимир
,Databases will stay opened until the full query has been evaluated.One of the reasons is that it’s not trivial to detect when the lastrelevant read operation will take place in a query.Could you share your query with us (or relevant parts of it)?Best,ChristianOn Thu, Aug 16, 2018 at 11:44 AM Ветошки

Re: [basex-talk] archive:create

2018-08-17 Thread Ветошкин Владимир
Christian, thank you very much!It works! :) 17.08.2018, 17:58, "Christian Grün" :Try serialize($doc) instead of $doc. Ветошкин Владимир <en-tra...@yandex.ru> schrieb am Fr., 17. Aug. 2018, 16:55:Hi! I want to write xml-data to zip-archive. I try something like this:       

[basex-talk] archive

2018-08-22 Thread Ветошкин Владимир
Hi! Because of the size, is there a way to store xml-data as archive (with possibility to search) ? -- С уважением,Ветошкин Владимир Владимирович 

[basex-talk] rest parallel

2018-08-25 Thread Ветошкин Владимир
Hi! Why do requests to RESTXQ wait for finishing each other?For example:declare  %rest:path("/test")  %rest:GET  function page:test(){  prof:sleep(5000)}; If I make 2 requests to /test, the first ends in 5 sec, the second - in 10 sec. -- С уважением,Ветошкин Владимир Владимирович 

Re: [basex-talk] rest parallel

2018-08-25 Thread Ветошкин Владимир
Hmm.. When I request "test" in 2 tabs of chrome - only one job appears.But when I request the first "test" in one tab and the second "test" in another browser (or in incognito tab) - two jobs appears. 25.08.2018, 21:36, "Ветошкин Владимир" :Hi, Christian! 

Re: [basex-talk] rest parallel

2018-08-25 Thread Ветошкин Владимир
That seems to be the case.Thanks. 25.08.2018, 22:18, "Christian Grün" :I see. So this must be an issue with Chrome (and, possibly, requests to localhost).  Ветошкин Владимир <en-tra...@yandex.ru> schrieb am Sa., 25. Aug. 2018, 21:16:Hmm.. When I request "test" in 2 tab

Re: [basex-talk] rest parallel

2018-08-25 Thread Ветошкин Владимир
h other? For example: declare   %rest:path("/test")   %rest:GET   function page:test() {   prof:sleep(5000) }; If I make 2 requests to /test, the first ends in 5 sec, the second - in 10 sec.  -- С уважением,Ветошкин Владимир Владимирович 

Re: [basex-talk] rest parallel

2018-08-29 Thread Ветошкин Владимир
Hi! Why are there max 7 jobs in the job list?I have tried changing PARALLEL parameter - no effect. 25.08.2018, 22:39, "Ветошкин Владимир" :That seems to be the case.Thanks. 25.08.2018, 22:18, "Christian Grün" <christian.gr...@gmail.com>:I see. So this must be an issue

Re: [basex-talk] archive

2018-08-22 Thread Ветошкин Владимир
ip')If you create databases, you can specify ZIP files as input, too.  -- С уважением,Ветошкин Владимир Владимирович 

Re: [basex-talk] archive

2018-08-22 Thread Ветошкин Владимир
Best regards, [1] http://basex.org/2018/03/23/basex-9.0--the-spring-edition/ BaseX -Message d'origine- De : BaseX-Talk [mailto:basex-talk-boun...@mailman.uni-konstanz.de] De la part de Christian Grün Envoyé : mercredi 22 août 2018 17:08 À : Ветошкин Владимир Cc : BaseX Objet : Re: [basex-talk]

Re: [basex-talk] rest parallel

2018-08-29 Thread Ветошкин Владимир
t, so once again I guess it’srelated to your testing environment. Feel free to give us moredetails.On Wed, Aug 29, 2018 at 9:20 AM Ветошкин Владимир <en-tra...@yandex.ru> wrote:  Hi! Why are there max 7 jobs in the job list? I have tried changing PARALLEL parameter - no effect. 25.08.2018,

Re: [basex-talk] Full-Text

2018-07-20 Thread Ветошкин Владимир
y have seen, I have simplified `/.//*` to `//*` (but maybe itwas optimized to this representation anyway).Cheers,Christian  -- С уважением,Ветошкин Владимир Владимирович 

Re: [basex-talk] Full-Text

2018-07-20 Thread Ветошкин Владимир
ou will do db names with the particular prefix, for example "db_", you may use the next code let $docs := for $i in db:list()[starts-with(.,"db_")] return db:open($i)return $docs/* On Mon, Jun 25, 2018 at 12:32 PM Ветошкин Владимир <en-tra...@yandex.ru> wrote: Hi,

Re: [basex-talk] Full-Text

2018-07-20 Thread Ветошкин Владимир
иль")/parent::* for $node in $ft return $node 2138 rows Why do they work differently?  -- С уважением,Ветошкин Владимир Владимирович 

Re: [basex-talk] Full-Text

2018-07-20 Thread Ветошкин Владимир
ming using language 'ru']  }I added a note in our documentation [1]. Another option is (as youalready found out) to directly use ft:search.Cheers,Christian[1] http://docs.basex.org/wiki/Indexes#Enforce_RewritingsOn Fri, Jul 20, 2018 at 11:54 AM Ветошкин Владимир <en-tra...@yandex.ru> wrote:  Qu

Re: [basex-talk] Full-Text

2018-07-22 Thread Ветошкин Владимир
Hi! After some tests of search (using stemming, using language ru) I have found several problems.E.g.:if search for "кузов" - it doesn't find "кузова"  20.07.2018, 14:26, "Ветошкин Владимир" :Christian, you're genius :)Thank you very much for your help! 20.0

[basex-talk] load invalid xml

2018-07-22 Thread Ветошкин Владимир
Hi, everybody! Is there any way to load invalid xml file to database?I have attached an example of such a file. -- С уважением,Ветошкин Владимир Владимирович  http://www.w3.org/2001/06/soap-envelope; xmlns:app="urn:customs.ru:Envelope:ApplicationInf:1.0"

Re: [basex-talk] php basex

2018-07-23 Thread Ветошкин Владимир
The query:for $i in (1 to 50)return $i In GUI: 200msIn PHP: 25sec. it is because of the result size, is it?  23.07.2018, 12:24, "Ветошкин Владимир" :Probably, it's because of the result size (~1.5mb).When I reduce the count of the returning data - execution time decreases.Th

Re: [basex-talk] php basex

2018-07-23 Thread Ветошкин Владимир
ce of our client [1]? Suggestions are welcome.Best,Christian[1] https://github.com/BaseXdb/basex/blob/master/basex-api/src/main/php/BaseXClient.phpOn Mon, Jul 23, 2018 at 11:35 AM Ветошкин Владимир <en-tra...@yandex.ru> wrote:  The query: for $i in (1 to 50) return $i In GUI: 200ms In PHP

Re: [basex-talk] load invalid xml

2018-07-23 Thread Ветошкин Владимир
If you only want to store data without querying it, you can store a document as binary (raw) data. Feel free to check out our documentation to find more details. Ветошкин Владимир <en-tra...@yandex.ru> schrieb am So., 22. Juli 2018, 09:44: Hi, everybody! Is there any way to load invalid xml

Re: [basex-talk] Full-Text

2018-07-23 Thread Ветошкин Владимир
with other stemmers that are available in the wild? Ветошкин Владимир <en-tra...@yandex.ru> schrieb am So., 22. Juli 2018, 14:30:Hi! After some tests of search (using stemming, using language ru) I have found several problems.E.g.:if search for "кузов" - it doesn't find "кузова

[basex-talk] php basex

2018-07-23 Thread Ветошкин Владимир
Hi! One thing puzzles me. Why does the same query take different execution time in GUI and PHP ?In GUI - 2.5-3sec, in PHP - 8-10sec. -- С уважением,Ветошкин Владимир Владимирович 

Re: [basex-talk] php basex

2018-07-23 Thread Ветошкин Владимир
a, you could e.g.write a little self-contained XQuery _expression_ that creates data ofthe same size.  -- С уважением,Ветошкин Владимир Владимирович 

Re: [basex-talk] php basex

2018-07-23 Thread Ветошкин Владимир
thub.com/BaseXdb/basex/blob/master/basex-api/src/main/php/BaseXClient.php On Mon, Jul 23, 2018 at 11:35 AM Ветошкин Владимир <en-tra...@yandex.ru> wrote:  The query:  for $i in (1 to 50)  return $i  In GUI: 200ms  In PHP: 25sec.  it is because of the result size, is it?  23.07.2018, 12:24, &qu

Re: [basex-talk] php basex

2018-07-23 Thread Ветошкин Владимир
There is something strange...socket_recv executes much longer than socket_read.. For this:string-join(1 to 10, out:nl())socket_recv takes ~3secsocket_read takes ~1-3ms I don't understand why...  23.07.2018, 13:37, "Ветошкин Владимир" :>> I assume you have communicated with

Re: [basex-talk] Full-Text

2018-07-19 Thread Ветошкин Владимир
you will do db names with the particular prefix, for example "db_", you may use the next codelet $docs := for $i in db:list()[starts-with(.,"db_")] return db:open($i)return $docs/* On Mon, Jun 25, 2018 at 12:32 PM Ветошкин Владимир <en-tra...@yandex.ru> wrote:Hi, Alexander

Re: [basex-talk] ubuntu 18.04 (bionic)

2019-01-31 Thread Ветошкин Владимир
Hi, Michael, Is that the only way to install it to ubuntu 18.04?  31.01.2019, 12:27, "Michael Seiferle" :Hi,  feel free to use the ZIP-file provided at http://files.basex.org/releases/9.1.2/ it should be up to date :)  BestMichael  On Thu, Jan 31, 2019 at 10:23 AM Ветошкин Владим

[basex-talk] ubuntu 18.04 (bionic)

2019-01-31 Thread Ветошкин Владимир
Hi! There is only 8.5.1 version for Ubuntu 18.04 at url https://launchpad.net/basex/+packagesIs there 9 version for that Ubuntu ? Thx -- С уважением,Ветошкин Владимир Владимирович 

[basex-talk] x509

2019-07-04 Thread Ветошкин Владимир
Hi! Does basex have functions to generate or get information from x509certificate?(like xdmp:x509-certificate-* in MarkLogic) -- С уважением,Ветошкин Владимир Владимирович 

[basex-talk] server load

2019-07-05 Thread Ветошкин Владимир
Hi BaseX team, I have uploaded about 3700 xml-files (450mb) to db.CPU usage at that time was about 100%.Is there any way to reduce the server load?May be basex has some kind of settings? Thank you  -- С уважением,Ветошкин Владимир Владимирович 

Re: [basex-talk] read file permissions

2019-08-21 Thread Ветошкин Владимир
g 20, 2019 at 3:20 PM Ветошкин Владимир <en-tra...@yandex.ru> wrote: Hi, everybody. I think my goal is simple, but I don't how to solve it :) How to grant user to read the file (xml)? Or all files in a directory. The user has only permissions to read some databases. -- С уважением, В

[basex-talk] read file permissions

2019-08-20 Thread Ветошкин Владимир
Hi, everybody. I think my goal is simple, but I don't how to solve it :)How to grant user to read the file (xml)? Or all files in a directory.The user has only permissions to read some databases. -- С уважением,Ветошкин Владимир Владимирович 

Re: [basex-talk] server load

2019-07-07 Thread Ветошкин Владимир
ly the I/O usage should be higher than the CPU usage. How muchRAM do you have, and how many CPUs cores are available on your system(I guess only 1 of the cores was used)?  -- С уважением,Ветошкин Владимир Владимирович 

Re: [basex-talk] x509

2019-07-07 Thread Ветошкин Владимир
com> wrote:Hi Владимир,Currently no. But maybe this could be included in the latest versionof the the EXPath Cryptography Module [1] (cc @Claudius)?Best,Christian[1] http://expath.org/spec/crypto/editorOn Thu, Jul 4, 2019 at 5:01 PM Ветошкин Владимир <en-tra...@yandex.ru> wrote:>> Hi!

[basex-talk] jobs

2020-02-27 Thread Ветошкин Владимир
Hi! Is it possible to add a job under specified user or only admin?I have a base with accessing only for userA. And I want to add a job with queries to that base under userA.  -- С уважением,Ветошкин Владимир Владимирович 

Re: [basex-talk] jobs

2020-02-27 Thread Ветошкин Владимир
I solved it by the function "client:connect"Is it right? 27.02.2020, 13:26, "Ветошкин Владимир" :Hi! Is it possible to add a job under specified user or only admin?I have a base with accessing only for userA. And I want to add a job with queries to that base under userA.  -- 

Re: [basex-talk] jobs

2020-02-27 Thread Ветошкин Владимир
e xquery:eval to run some code with restrictedpermissions (but the query won’t be evaluated as independent job).Hope this helps,Christian 27.02.2020, 13:26, "Ветошкин Владимир" <en-tra...@yandex.ru>: Hi! Is it possible to add a job under specified user or only admin? I have a base

Re: [basex-talk] db:optimize

2020-01-29 Thread Ветошкин Владимир
not connect to the server instance of BaseX, so you may encounter conflicts. Did your the Wiki pages referenced by.. "first name last name"?Ветошкин Владимир <en-tra...@yandex.ru> schrieb am Mi., 29. Jan. 2020, 19:05:Hi, Christian! I hope you're well.No, there is only one client at this tim

Re: [basex-talk] db:optimize

2020-01-29 Thread Ветошкин Владимир
my problems. Am I right doing so?The 'basex' standalone client does not connect to the server instance of BaseX, so you may encounter conflicts. Did your the Wiki pages referenced by.. "first name last name"?Ветошкин Владимир <en-tra...@yandex.ru> schrieb am Mi., 29. Jan. 2020, 19:05:Hi, Ch

Re: [basex-talk] db:optimize

2020-01-29 Thread Ветошкин Владимир
maybeyou need to use parallel or pthreads and do the work via multiplethreads. Are you already working with several BaseX client instances?ChristianOn Wed, Jan 29, 2020 at 10:14 AM Ветошкин Владимир <en-tra...@yandex.ru> wrote: Thank you. 29.01.2020, 12:02, "first name last name"

Re: [basex-talk] db:optimize

2020-01-30 Thread Ветошкин Владимир
I suppose, there is something interesting in the core of website.If I isolate two php functions (one only update, one only read) - everything is ok.But If I update and read from the core of website - reading function waits finishing updating function.  30.01.2020, 11:17, "Ветошкин Владимир&q

Re: [basex-talk] db:optimize

2020-01-30 Thread Ветошкин Владимир
I have found a reason.There was a query with non-static database names and because of that global lock.Thank you for your help! 30.01.2020, 12:10, "Ветошкин Владимир" :I suppose, there is something interesting in the core of website.If I isolate two php functions (one only update, one

Re: [basex-talk] db:optimize

2020-01-30 Thread Ветошкин Владимир
Hmm..If I run [basex -q"db:optimize('A')"], I can read from db 'B'.But if I run [basexclient -Uadmin -Padmin -q"db:optimize('A')"], I can't read from db 'B'. 29.01.2020, 21:48, "Ветошкин Владимир" :Yes, the system works on php and I can call basex only via php client

Re: [basex-talk] db:optimize

2020-01-30 Thread Ветошкин Владимир
re()) {$data = "">}$query->close();$session->close(); The second code starts only after the first finished. If in the first code I use "org.basex.BaseX" instead of "org.basex.BaseXClient" - the second code starts immediately.  30.01.2020, 11:05, "Christian Gr

[basex-talk] db:optimize

2020-01-28 Thread Ветошкин Владимир
Hi, everybody! I use basex+php.When I call db:optimize('A') from basex gui I can read from db 'B'.But if I call db:optimize('A') from php (php cli) I can't read 'B' while the first query is working.Why? And how can I solve it?I wracked my brain... -- С уважением,Ветошкин Владимир Владимирович 

Re: [basex-talk] db:optimize

2020-01-29 Thread Ветошкин Владимир
ur data, however, you shouldn’t use the GUI or a standalone instance at the same time." [1] http://docs.basex.org/wiki/Startup#Concurrent_Operations On Wed, Jan 29, 2020 at 9:25 AM Ветошкин Владимир <en-tra...@yandex.ru> wrote:Hi, everybody! I use basex+php.When I call db:optimize('A') from

[basex-talk] txtl.basex

2020-05-19 Thread Ветошкин Владимир
Hi, basex team. The base has enabled attributes - updindex and autooptimize.Why value index files (txtl.basex) are very large after time? (643MB)db:optimize with true as the second parameter optimize the database to the size 32MB.(basex 9.1.2)

Re: [basex-talk] txtl.basex

2020-05-19 Thread Ветошкин Владимир
o optimize your database in regularintervals.BestChristianOn Tue, May 19, 2020 at 1:30 PM Ветошкин Владимир <en-tra...@yandex.ru> wrote: Hi, basex team. The base has enabled attributes - updindex and autooptimize. Why value index files (txtl.basex) are very large after time? (643MB) db:op

[basex-talk] patterns

2020-05-21 Thread Ветошкин Владимир
Hi, basex team! How can I use regex in patterns? Or that's impossible?For example,user:grant('000590',('write'),('000590-\d{2,3}_settings'))Or only so:user:grant('000590',('write'),('000590-*_settings'))

Re: [basex-talk] patterns

2020-05-21 Thread Ветошкин Владимир
u cancreate multiple patterns…  for $n in 10 to 999  return user:grant('000590', 'write', '000590-' || $n || '_settings')…but you should do some performance tests before going live with that.Best,Кристиан[1] https://docs.basex.org/wiki/Commands#Glob_SyntaxOn Thu, May 21, 2020 at 3:32 PM Ветош