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.
-- С уважением, Ветошкин Владимир Владимирович
-- С уважением, Ветошкин Владимир Владимирович