https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 --- Comment #22 from Jacek Ablewicz <abl@biblos.pk.edu.pl> --- (In reply to Jonathan Druart from comment #21)

(In reply to Jonathan Druart from comment #20)

...

Created attachment 56012 [details] [review] [review] Bug 15341: Retrieve all sysprefs at once

Jacek, did you have something like that in mind?

Something like that, yes - i.e. that retrieving all sysprefs together from L2 cache, as a single data structure, should be (arguably) better then fetching 80-150 scalars individually per script run. I expect there will be some speed improvements involved (nothing really major, maybe 5-10 msec on average), but the main benefit from such change would be the possibility to use the upstream (L2) cache more effectively. E.g.: for a start: no more need to call ->flush_all() in clear_syspref_cache(), ->clear_from_cache("sysprefs") will do the trick, without clearing all other existing L2 cache entries. If you are using the single memcached instance for multiple tenants (or worse: storing user sessions in the very same cache), avoiding ->flush_all() like a plague may be kind of important. -- You are receiving this mail because: You are watching all bug changes.