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.gr...@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.

 
 
-- 
С уважением,
Ветошкин Владимир Владимирович
 

Reply via email to