Hi, Christian! Thank you for your reply!
I attached the file.
I thought about "random access patterns" But all databases are on one disk. So, why two queries to different databases complete in about 5 sec? And if these queries make to one database - it takes a long time...
by setting the PARALLEL option to 1
It helped a bit. Now the second script is waiting for finishing the first. But I would like to see a parallel execution of these queries. Is it possible without long waiting? May be it is possible to load database (or some nodes) in memory to avoid heavy load the disk?
23.05.2018, 22:54, "Christian Grün" christian.gruen@gmail.com:
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@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@gmail.com:
Привет Ветошкин,
Welcome to the list. Just send your question to this address.
Best, Christian
Ветошкин Владимир en-trance@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?
-- С уважением, Ветошкин Владимир Владимирович
-- С уважением, Ветошкин Владимир Владимирович