https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36350 --- Comment #33 from David Gustafsson <glasklas@gmail.com> --- (In reply to Michał from comment #27)
I'm somewhat curious, could you benchmark before applying the patch but with MariaDB query cache enabled to see how it compares against the two other benchmark results?
I understand this uses Koha::Cache::Memory::Lite, is it theoretically possible to use Memcached ?
I don't think it's a good idea, it could flood the memcached storage severely and potentially be not much faster if not slower than just retrieval with SQL, plus longer-term preservation of cache in this manner could lead to way more issues/risks, such as someone updating the database externally or with some maintenance script.
The database query itself constitutes only a tiny fraction of the overhaed, like less than a few percent at most, query cache or not, it's the DBIx magic that is the major problem. -- You are receiving this mail because: You are watching all bug changes.