Bug 35438: Transact each record import separately
authorKyle M Hall <kyle@bywatersolutions.com>
Thu, 30 Nov 2023 17:10:41 +0000 (12:10 -0500)
committerKatrin Fischer <katrin.fischer@bsz-bw.de>
Tue, 16 Jan 2024 11:06:07 +0000 (12:06 +0100)
commit74bbb89e9941aab7bf3f946d663d0d66b9df4021
treea8c89766ef715f21b8edc64bd558a0358f8eae65
parent4d3c83809353c3643b86389b27c141b340479218
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>
C4/ImportBatch.pm