https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42547
Bug ID: 42547
Summary: SIP performance is terrible if
sip2_resource_last_modified is missing from memcached
Initiative type: ---
Sponsorship ---
status:
Product: Koha
Version: Main
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: P5 - low
Component: SIP2
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
In Koha, the sip2_resource_last_modified key is updated any time the SIP config
is edited from the SIP2 editor in the staff interface ( institutions, accounts,
system preference overrides ).
If sip2_resource_last_modified is missing from memcached, Koha SIP emits
"Couldn't find sip2_resource_last_modified, considering configuration not up to
date" in the logs, and fetches the entire configuration from the database, *for
each request*.
This causes SIP performance to drop significantly. In my production testing
with 83 institutions and 171 accounts the login message response time dropped
from 0.283 seconds to 2.899 seconds.
I think the solution is pretty simple. If there is a cache miss on
sip2_resource_last_modified, SIP should load the config from database as it
does already, but then it should also set sip2_resource_last_modified!
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
