There is something strange...socket_recv executes much longer than socket_read.. For this:string-join(1 to 10, out:nl())socket_recv takes ~3secsocket_read takes ~1-3ms I don't understand why... 23.07.2018, 13:37, "Ветошкин Владимир" :>> I assume you have communicated with your local BaseX
>> I assume you have communicated with your local BaseX instance?Yes,$session = new Session("localhost", $this->dbport, $this->dblogin, $this->dbpass); 23.07.2018, 13:19, "Christian Grün" : 1. in GUI ~200ms, in PHP ~17sec 2a. ~23sec 2b. ~17secI see. So this clearly indicates that it’s the result
> 1. in GUI ~200ms, in PHP ~17sec
> 2a. ~23sec
> 2b. ~17sec
I see. So this clearly indicates that it’s the result size (the number
of results has an effect as well, but it doesn’t seem to be that
dominant). The Java client is much faster indeed. I assume you have
communicated with your local
1. in GUI ~200ms, in PHP ~17sec2a. ~23sec2b. ~17sec >> Maybe there are simple ways to improve the performance of our client [1]?Maybe... I'll try to explore this issue better. 23.07.2018, 12:44, "Christian Grün" :Hi Vladimir,Thanks for the example. This is quite an impressive difference indeed.Two
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 50, out:nl()) ?
2. What are the execution times in PHP when running
a) execute('xquery ...')
b) query('...') and more()/next() ?
The query:for $i in (1 to 50)return $i In GUI: 200msIn PHP: 25sec. it is because of the result size, is it? 23.07.2018, 12:24, "Ветошкин Владимир" :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
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 -
> 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
8 matches
Mail list logo
