Bug 19792: Performance boost for GetBudgetHierarchy
authorDavid Bourgault <david.bourgault@inlibro.com>
Mon, 11 Dec 2017 16:56:27 +0000 (11:56 -0500)
committerJonathan Druart <jonathan.druart@bugs.koha-community.org>
Fri, 11 May 2018 13:52:46 +0000 (10:52 -0300)
commit1edd7f8265b5e51f3e651c207ee8c3301273891f
tree864618a01ea6fb5a0d622ffa502893226df57b80
parent5347537f1ab216dd283a5c85604b28d6f2d5c21c
Bug 19792: Performance 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@lboro.ac.uk>

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>

Signed-off-by: Jon Knight <J.P.Knight@lboro.ac.uk>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
C4/Budgets.pm
acqui/acqui-home.pl