[Koha-bugs] [Bug 29623] Cache effective circulation rules

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

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

--- Comment #39 from David Cook <dcook at prosentient.com.au> ---
(In reply to Tomás Cohen Arazi from comment #36)
> MySQL will be doing disk I/O on the first request for the same thing. I'm
> pretty sure the caching strategy in MySQL is far better than ours and
> memcached.

While I know what you mean about the disk caching, I'm not sure what you mean
about it being better than ours. Caching a rule once per HTTP request makes
more sense to me than fetching it X times over the course of that HTTP request. 

That said, it all depends on the volume. When working with hundreds, thousands,
and millions, even fractional second lags add up. (I've had a lot of fun with
that over the years just in terms of the difference in TCP lag of connecting to
local TCP sockets vs remote TCP sockets.)

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