[Koha-bugs] [Bug 6193] Use memcached cache koha-conf.xml configuration variables

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6193

Paul Poulain <paul.poulain at biblibre.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |paul.poulain at biblibre.com

--- Comment #11 from Paul Poulain <paul.poulain at biblibre.com> 2011-11-25 17:55:30 UTC ---
Some performance tests:
(using an updated version of benchmark_circulation i'll push soon)

WITHOUT THIS PATCH:
misc/load_testing/benchmark_circulation.pl
http://koha-community:8080/cgi-bin/koha/ test test
Authentication successful
--------------
Koha circulation benchmarking utility
--------------
Benchmarking with 20 occurences of each operation and 30 concurrent sessions 
Load testing staff client dashboard page    27460ms    0.728332119446468
pages/sec
Load testing catalog detail page    29092ms    0.687474219716761 biblios/sec
Load testing patron detail page    32413ms    0.617036374294265 borrowers/sec
Load testing patron search page    60148ms    0.665026268537607 borrowers/sec

WITH THIS PATCH:
misc/load_testing/benchmark_circulation.pl
http://koha-community:8080/cgi-bin/koha/ test test
Authentication successful
--------------
Koha circulation benchmarking utility
--------------
Benchmarking with 20 occurences of each operation and 30 concurrent sessions 
Load testing staff client dashboard page    26654ms    0.750356419299167
pages/sec
Load testing catalog detail page    25688ms    0.77857365306758 biblios/sec
Load testing patron detail page    29681ms    0.67383174421347 borrowers/sec
Load testing patron search page    56895ms    0.703049477106951 borrowers/sec

=> the gain is not huge, but real. This is due to the fact that the decoding of
the XML is replaced by the time for Koha to reach memcache server & get an
answer.
We should not miss that memcache is more dedicated to removing load on mySQL
than gaining speed.
I also have a patch from Ian that change the conf into a YAML file. It seems
decoding a YAML is very fast. I'll run the tests as well, attach ian patch here
and report the results.
Thus we will see which patch give the best speed and decide which we can/should
apply.

-- 
Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA Contact for the bug.
You are watching all bug changes.