[Koha-bugs] [Bug 29386] baground jobs table data field is a TEXT which is too small

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29386

--- Comment #2 from Jonathan Druart <jonathan.druart+koha at gmail.com> ---
I have been running some tests

BatchUpdateBiblio will have data with
230   chars for 1   record
836   chars for 10  records
7065  chars for 100 records
28470 chars for 400 records

Seems linear so currently the tool has a limit of 800 records.

Switching to MEDIUMTEXT will allow ~230k records
Switching to LONGTEXT   will allow ~60M records

This is only an estimate (and the maximum), as the tool can log error, extra
info, etc. which will take more characters.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.