[Koha-bugs] [Bug 35579] New: marcrecord2csv searches authorised values inefficiently

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

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

            Bug ID: 35579
           Summary: marcrecord2csv searches authorised values
                    inefficiently
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: P5 - low
         Component: MARC Bibliographic data support
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: dcook at prosentient.com.au
        QA Contact: testopia at bugs.koha-community.org

If you have a CSV export profile with a large number of fields, and you have a
list with a large number of records, you end up making the exact same database
calls thousands of times.

This chews up CPU like crazy and it can also mean your list never downloads as
the proxy times out. 

So we need to cache! 

Koha::AuthorisedValues already caches when getting descriptions by
"koha_field", but it does *not* when getting descriptions by "marc_field".

Koha::AuthorisedValues->search_by_marc_field is actually only ever used by
C4::Record for CSV exports anyways so that's probably why this hasn't come up
before...

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