]> git.koha-community.org Git - koha.git/commit
Bug 30984: (QA follow-up) Switch from mediumtext to varchar(255)
authorKyle Hall <kyle@bywatersolutions.com>
Fri, 29 Jul 2022 10:53:06 +0000 (06:53 -0400)
committerTomas Cohen Arazi <tomascohen@theke.io>
Mon, 1 Aug 2022 12:21:38 +0000 (09:21 -0300)
commit526606901626082831ab501609cf05e360551ce1
tree2aaf21f1eea5a0020e30ab4e664884c14124ebc8
parentb3a0d75a40cfeec8e14d7092b4cf23763363b45a
Bug 30984: (QA follow-up) Switch from mediumtext to varchar(255)

My research indeicates that tinytext of less than 40 bytes uses
about the same storage as a varchar(255). Also, using
a TEXT field in a complex query may create a temp table.
varchar fields are also more efficient for sorting on.

Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
installer/data/mysql/atomicupdate/bug_30984.pl
installer/data/mysql/kohastructure.sql