Bug 35438: Transact each record import separately
authorKyle M Hall <kyle@bywatersolutions.com>
Thu, 30 Nov 2023 17:10:41 +0000 (12:10 -0500)
committerFridolin Somers <fridolin.somers@biblibre.com>
Wed, 17 Jan 2024 09:30:13 +0000 (10:30 +0100)
commitcc4f879465d19e9ac761809497281f8b88145ac5
tree42e60bea981c74465ba74df574f1f1e12c9abbd6
parent043fd7ffa4144467ec2af2672e11c675eda933e8
Bug 35438: Transact each record import separately

When importing a staged file we commit every 50 records
For an authority import we are also merging, which can affect many more biblios, and these all end up in the transaction.
This can cause tables locks and issues across Koha

Test Plan:
1) Apply this patch
2) prove t/db_dependent/ImportBatch.t

Signed-off-by: David Nind <david@davidnind.com>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Katrin Fischer <katrin.fischer@bsz-bw.de>
(cherry picked from commit 74bbb89e9941aab7bf3f946d663d0d66b9df4021)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
C4/ImportBatch.pm