https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43766 Bug ID: 43766 Summary: Performance issues when staging a large file into a basket Initiative type: --- Sponsorship --- status: Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Acquisitions Assignee: koha-bugs@lists.koha-community.org Reporter: nick@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org Target Milestone: --- Noting issues here that we can fix, I am still profiling to look for more, but some low hangning fruit: Koha/Import/Record.pm: sub _get_syspref_mappings { fetches the same yaml pref for each biblio - can be fetched and passed through to reduce call This sub also calls: sub _verify_number_of_fields { Which loops through the record to count the fields - we verify the count, then return to the caller and loop through the fields again to store them - we should store during the count and pass back We call 'GetBudgetByCode' for each record/item - and we don't cache or reuse - we should do this to reduce calls (especially as orders are often grouped by budget) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.