progress of query execution

Hi, everybody! My core has written in php and php-script execute xquery-scripts to get needed data. To get the progress of one large query I have to divide it into some small ones. Isn't it? Are there any more options? Maybe it is possible to get number of seconds, which needed to complete execution of query?

Hi Владимир (which is your first name I guess?),

Exactly. You can pass on additional arguments (start, end) to the server and return only the requested results:

  let $result := ...
  return $result[position() = $start to $end]

Additionally, you can try to reduce the size of the returned data if your PHP client does not require the full result.

For assessing the total execution time, the full query must be evaluated. There can be various reasons why query execution is too slow in practice. Could you give us more information on your use case? Do you e.g. have a web site, and your users want to see the first results more quickly? Or is your connection bandwidth limited? Yours respectfully, Christian