https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17941
--- Comment #9 from Petter Goksøyr Åsen <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://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/
