[Koha-bugs] [Bug 12017] Move language description out of database

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Jun 18 12:00:37 CEST 2015


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

--- Comment #86 from Julian FIOL <julian.fiol at biblibre.com> ---
I wanted to add that this patch optimize the number of MySQL requests in a
significant way :

On the mainpage with 3 languages installed and activated we save 67 queries for
each load. 
This is a good MySQL optimization.


Test plan
---------

1. mysql> SHOW GLOBAL STATUS
      Com_select  = X1 (number of queries like 'SELECT ...')
      Qcache_hits = Y1 (number of queries automatically cached by MySQL)

2. Reload your mainpage

3. mysql> SHOW GLOBAL STATUS
      Com_select  = X2
      Qcache_hits = Y2

4. (X2 + Y2) - (X1 + Y1) = number of queries saved

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list