[Koha-bugs] [Bug 30359] New: GetBudgetHierarchy is slow on order receive page

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Fri Mar 25 10:49:38 CET 2022


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30359

            Bug ID: 30359
           Summary: GetBudgetHierarchy is slow on order receive page
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Acquisitions
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: johanna.raisa at koha-suomi.fi
        QA Contact: testopia at bugs.koha-community.org

GetBudgetHierarchy is called when opening orderreceive.pl and if there are lot
of budgets the page takes lot of time to open. On our biggest groups it takes
almost 2 minute, which is a lifetime on internet.

Seems that the problem is calculating the totals, which are done with separate
queries to the database. On the order receive page it is not needed since it is
using only the budget_id, budget_amount and budget_name parameters.

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.


More information about the Koha-bugs mailing list