[Koha-bugs] [Bug 12001] New: GetMemberAccountRecords slows down display of patron details and checkout pages

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12001

            Bug ID: 12001
           Summary: GetMemberAccountRecords slows down display of patron
                    details and checkout pages
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Architecture, internals, and plumbing
          Assignee: gmcharlt at gmail.com
          Reporter: gmcharlt at gmail.com
        QA Contact: testopia at bugs.koha-community.org

For patrons who have a large number of fines (whether they're paid off or not),
the current implementation of GetMemberAccountRecords is needlessly slow, as it
retrieves the title and author for every fine record that is linked to an item.

This is particularly noticeable in setups where the database server is accessed
over the network instead of a local socket.

This is particularly obnoxious because the majority of callers of
GetMemberAccountRecords() are only interested in the total fine balance, and
toss away the detailed information.  GetMemberDetails() is a good example --
and consequently, there are several contexts where it would be preferable to
use GetMember() rather than GetMemberDetails().

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