https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33488 Bug ID: 33488 Summary: Branch transfer limits should have an index on fromBranch Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs@lists.koha-community.org Reporter: nick@bywatersolutions.com QA Contact: testopia@bugs.koha-community.org In a consortium with many libraries, the branch transfer limits can become complex and have many rows - we have seen 750k+ At this size, searching on limits can take 1/2 a second or more - and when a record has many items this begins to add up fast Adding an index to the fromBranch column greatly reduces the cost of a lookup: CREATE INDEX fromBranch_index ON branch_transfer_limits (fromBranch); -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.