[Koha-bugs] [Bug 15341] Performance - Retrieve all sysprefs at once

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Mon Sep 2 09:04:05 CEST 2019


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341

David Cook <dcook at prosentient.com.au> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dcook at prosentient.com.au

--- Comment #23 from David Cook <dcook at prosentient.com.au> ---
Looks like an old one, but I've often wondered why we haven't fetched all the
system preferences at once to avoid subsequent calls to the database. 

I suppose it does introduce overhead though as you are getting everything when
in practice you might only use a few preferences. And the more preferences you
have, the slower that fetch will become. It wouldn't scale. 

I suppose the L1/L2 caching we have now should take care of this, although I'm
trying to see where the L2 cache gets intialized...

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


More information about the Koha-bugs mailing list