https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31222 Bug ID: 31222 Summary: DBIC queries for batch mod can be very large 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 We had an issue with mysql logging for a site doing many batch modifications. The object search is currently: Koha::Items->search({ barcode => \@contentlist } Which generate code like: barcode = 1 OR barcode = 2 OR barcode = 3 .... This can get quite large We can reduce the query size by using -in: Koha::Items->search({ barcode => { -in => \@contentlist } } Which generates code like: barcode in ( 1, 2, 3 ) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.