Re: Benchmarking SQL drivers

"Stephen R. van den Berg" <[email protected]>
Newsgroups gmane.comp.lang.pike.user
Message-ID <[email protected]>
And yet some more simplifications:

>This is 3940 queries running in batches of 1:
>16.2s  pgsql    Pike 8.1 (new driver, multithreaded)
>16.5s  MySQL    Pike 8.1
>15.2s  pgsql    Pike 7.8 (old driver, single threaded)
>21.3s  postgres Pike 8.1 (C-libpq)

We now get (batches of 1):
15.5s  pgsql    Pike 8.1 (new driver, multithreaded)
16.5s  MySQL    Pike 8.1
15.2s  pgsql    Pike 7.8 (old driver, single threaded)

>This is 3940 queries running in batches of 2:
>20.3s  pgsql    Pike 8.1 (new driver, multithreaded)
>19.4s  MySQL    Pike 8.1
>20.3s  pgsql    Pike 7.8 (old driver, single threaded)
>34.8s  postgres Pike 8.1 (C-libpq)

We now get (batches of 2):
20.0s  pgsql    Pike 8.1 (new driver, multithreaded)
19.4s  MySQL    Pike 8.1
20.3s  pgsql    Pike 7.8 (old driver, single threaded)

The higher batchcount tests yielded no significant difference to the 
previous benchark.

Getting even higher performance means that I would have to abandon the
Pike-only driver solution, and I would have to start using a cmod
helper module again.
However, since the new driver is only 2% slower than the old driver,
it is not worth the trouble to try and weed that out.
-- 
Stephen.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.