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

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

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

--- Comment #22 from Jacek Ablewicz <abl at 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.