php basex

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

>> 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 at 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.

23.07.2018, 12:24, "Ветошкин Владимир" <en-trance at 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 at 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. > > > -- > С уважением, > Ветошкин Владимир Владимирович >

On Mon, Jul 23, 2018 at 11:35 AM Ветошкин Владимир <en-trance at 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 at 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 at 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. > > > > -- > С уважением, > Ветошкин Владимир Владимирович > > > > > -- > С уважением, > Ветошкин Владимир Владимирович >

>> Maybe there are simple ways to improve the performance of our client [1]?

23.07.2018, 12:44, "Christian Grün" <christian.gruen at gmail.com>: > 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/BaseXClient.php > > > > On Mon, Jul 23, 2018 at 11:35 AM Ветошкин Владимир <en-trance at 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 at 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 at 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. > > > > > > > > -- > > С уважением, > > Ветошкин Владимир Владимирович > > > > > > > > > > -- > > С уважением, > > Ветошкин Владимир Владимирович > >

> 1. in GUI ~200ms, in PHP ~17sec > 2a. ~23sec > 2b. ~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" <christian.gruen at gmail.com>: > > 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/BaseXClient.php > > > > On Mon, Jul 23, 2018 at 11:35 AM Ветошкин Владимир <en-trance at 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 at 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 at 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. > > > > -- > С уважением, > Ветошкин Владимир Владимирович > > > > > -- > С уважением, > Ветошкин Владимир Владимирович > > > > > -- > С уважением, > Ветошкин Владимир Владимирович >

>> I assume you have communicated with your local BaseX instance?

23.07.2018, 13:19, "Christian Grün" <christian.gruen at gmail.com>: > > 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 BaseX instance? > > > > > >> 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" <christian.gruen at gmail.com>: > > > > 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/BaseXClient.php > > > > > > > > On Mon, Jul 23, 2018 at 11:35 AM Ветошкин Владимир <en-trance at 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 at 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 at 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. > > > > > > > > -- > > С уважением, > > Ветошкин Владимир Владимирович > > > > > > > > > > -- > > С уважением, > > Ветошкин Владимир Владимирович > > > > > > > > > > -- > > С уважением, > > Ветошкин Владимир Владимирович > >

23.07.2018, 13:37, "Ветошкин Владимир" <en-trance at yandex.ru>: > >> 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" <christian.gruen at gmail.com>: > > > > 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 BaseX instance? > > > > > > > > > >> 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" <christian.gruen at gmail.com>: > > > > > > 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/BaseXClient.php > > > > > > > > > > > > On Mon, Jul 23, 2018 at 11:35 AM Ветошкин Владимир <en-trance at 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 at 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 at 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. > > > > > > > > > > > > -- > > > С уважением, > > > Ветошкин Владимир Владимирович > > > > > > > > > > > > > > > -- > > > С уважением, > > > Ветошкин Владимир Владимирович > > > > > > > > > > > > > > > -- > > > С уважением, > > > Ветошкин Владимир Владимирович > > > > > > -- > С уважением, > Ветошкин Владимир Владимирович >