[Koha-bugs] [Bug 19792] Reduce number of SQL calls in GetBudgetHierarchy
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Wed May 2 17:24:58 CEST 2018
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19792
--- Comment #25 from Jon Knight <J.P.Knight at lboro.ac.uk> ---
Created attachment 74983
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=74983&action=edit
[SIGNED-OFF] Bug 19792 - Perf. boost for GetBudgetHierarchy
This patches reduces the number of SQL calls by combining multiple calls to the
recursive functions GetBudgetSpent(), GetBudgetOrdered(), etc. into 4 big
queries.
It also removes duplicate function calls from acqui-home.pl
Test plan:
0) Visit Acquisition home
0) Apply patch
1) Refresh page. It shoud look identical.
2) prove t/db_dependent/Budgets.t
Signed-off-by: Jon Knight <J.P.Knight at lboro.ac.uk>
Signed-off-by: Marcel de Rooy <m.de.rooy at rijksmuseum.nl>
Signed-off-by: Jon Knight <J.P.Knight at lboro.ac.uk>
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list