[Koha-bugs] [Bug 11998] Syspref caching issues

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

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

--- Comment #124 from Jacek Ablewicz <abl at biblos.pk.edu.pl> ---
Some (not very scientific) cache performace tests below. I measured
C4::Context->preference() calls; 3 scenarios:

A) feching 1 small syspref (marcflavour) over and over - syspref cache (almost)
unpopulated
B) feching 'marcflavour', cache fully populated (all 545 system preferencers in
cache)
C) feching all system prefrences in alphabetical order, cache fully populated,
average time spent in ->preference() call / per preference

Results (A / B / C):

- without patch (syspref cache = perl hashref): 1.1us / 1.1us / 0.9us
- Cache::Memory: 36us / 53us / 110us
- memcached: 41us / 41us / 42us
- fastmmap: 14us / 16us / 60us
- mysql query cache (256MB, DBI): ... / 130us / 135us
- mysql query cache (256MB, DBIx): ... / 1.20ms / 1.20ms

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