Bug 34480 - Reduce DB calls when importing patrons
Summary: Reduce DB calls when importing patrons
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Tools (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-08-04 18:20 UTC by Nick Clemens (kidclamp)
Modified: 2023-08-04 18:20 UTC (History)
0 users

See Also:
GIT URL:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Nick Clemens (kidclamp) 2023-08-04 18:20:25 UTC
sub check_branch_code {
sub check_borrower_category {

Both do a search of the db based on the values in the import file for each borrower - it seems we could lookup the allowed values once and cache them?

We also fetch the category another time to get the expiratoin date, it feels like we could store these early on.