Hi Vladimir,
Thanks for the example. This is quite an impressive difference indeed. Two more questions:
1. What is the execution time for running string-join(1 to 500000, out:nl()) ?
2. What are the execution times in PHP when running a) execute('xquery ...') b) query('...') and more()/next() ?
I don’t know much about PHP. Maybe there are simple ways to improve the performance of our client [1]? Suggestions are welcome.
Best, Christian
[1] https://github.com/BaseXdb/basex/blob/master/basex-api/src/main/php/BaseXCli...
On Mon, Jul 23, 2018 at 11:35 AM Ветошкин Владимир en-trance@yandex.ru wrote:
The query: for $i in (1 to 500000) return $i
In GUI: 200ms In PHP: 25sec.
it is because of the result size, is it?
23.07.2018, 12:24, "Ветошкин Владимир" en-trance@yandex.ru:
Probably, it's because of the result size (~1.5mb). When I reduce the count of the returning data - execution time decreases. The php-code of measuring execution time: $time_start = microtime(true); while ($query->more()) { $q = $query->next(); } $time_end = microtime(true); $execution_time = ($time_end - $time_start); echo $execution_time;
I'll try to do this:
you could e.g. write a little self-contained XQuery expression that creates data of the same size.
23.07.2018, 11:53, "Christian Grün" christian.gruen@gmail.com:
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.
There are too many factors that influence execution time (bandwidth, result size, etc.), so you will need to provide us with more information, such as a minimized code example that demonstrates your observations. Instead of providing your original data, you could e.g. write a little self-contained XQuery expression that creates data of the same size.
-- С уважением, Ветошкин Владимир Владимирович
-- С уважением, Ветошкин Владимир Владимирович