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

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Wed Nov 3 16:10:34 CET 2021


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

--- Comment #4 from Andrew Nugged <nugged at gmail.com> ---
What things hold us from allowing this to be LONGTEXT? Will fields occupy much
more space on disk as I thought and only? I had only things one from "cons" and
here people already thought the same:

"The only difference is the length field in the row data. Using MEDIUMTEXT
instead of LONGTEXT saves 1 byte per record. If you have 100 million records,
that saves 100 MB."
https://stackoverflow.com/questions/58225898/mysql-is-there-a-lack-of-performance-by-using-longtext-instead-of-mediumtext

no more cons from having LONGTEXT?

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


More information about the Koha-bugs mailing list