[Koha-bugs] [Bug 17941] CanBookBeRenewed is very inefficient/slow
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Tue Feb 7 12:01:17 CET 2017
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17941
--- Comment #9 from Petter Goksøyr Åsen <boutrosboutrosboutros at gmail.com> ---
Some adittional evidence from testings Fransesco's patch:
Here are the stats of cache hits/misses from one call to /svc/checkouts (on a
patron with 5 checkouts, 2 of them which has many holds)
hit miss
C4::Circulation::GetBranchItemRule 4537 21
C4::Reserves::_OnShelfHoldsAllowed 13 116
C4::Reserves::IsAvailableForItemLevelRequest 0 129
C4::Circulation::CanBookBeRenewed 0 5
C4::Items::GetItem 4845 33
C4::Members::GetMember 4075 584
C4::Reserves::CheckReserves 0 53
C4::Reserves::CanItemBeReserved 0 129
C4::Reserves::IsItemOnHoldAndFound 24 239
As you can see, we save almost 15 thousand DB-queries here!
We are most probably pushing this into production today.
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
More information about the Koha-bugs
mailing list