Bug 35438: Transact each record import separately
authorKyle M Hall <kyle@bywatersolutions.com>
Thu, 30 Nov 2023 17:10:41 +0000 (12:10 -0500)
committerLucas Gass <lucas@bywatersolutions.com>
Fri, 2 Feb 2024 17:47:39 +0000 (17:47 +0000)
commit84d0c6ac9bebb168f89acf317d982ab55caecffa
tree2f3e07124312f8822737a99e025518709153bd87
parent84cc07b507e1a56d5264a432548c9bb79a05177d
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>
(cherry picked from commit cc4f879465d19e9ac761809497281f8b88145ac5)
Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
C4/ImportBatch.pm