]> git.koha-community.org Git - koha.git/commit
Bug 31222: Reduce query size for batchMod
authorNick Clemens <nick@bywatersolutions.com>
Fri, 22 Jul 2022 14:47:36 +0000 (14:47 +0000)
committerLucas Gass <lucas@bywatersolutions.com>
Mon, 3 Oct 2022 22:35:50 +0000 (22:35 +0000)
commitdd5fcd9de3b6c9201c20e3b279f25649d1e7fac0
treec9bcbf24d1140d92b3bfad5e49311347bbd7ec3a
parentb9e26b55a14ba42a4d62364cc7ec1aac1fe4d461
Bug 31222: Reduce query size for batchMod

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 )

To test:
1 - Apply patch
2 - Perform batch modifications
3 - Confirm nothing has changed

Signed-off-by: Rachael Laritz <rachael.laritz@inlibro.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
(cherry picked from commit 7343e404b7b486c52a150613f308e452f4f5da05)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
tools/batchMod.pl