[Koha-devel] Other suggestions to clean DB...

[Tonnesen Steve]

I don't think you can restrict the subtitle to 255 characters.  If a
subtitle is longer than 255 characters, you have to have some way to store
it.  Also, if we store a unicode subtitle, you'd be restricting the title
to only 127 characters.  Newer mysql servers _can_ index blobs.  I believe
that you can set how many of the first characters of the blob are indexed.
If you _have_ to support indexing of subtitles with older mysql servers,
then maybe create a new subtitle_index table that contains the first 255
characters (or less) of the entries in the subtitle field.

Note that with the MARC DB schema I'm using, if a value is less than 255
characters, it is stored directly in the Subfield_Value table, if it is
longer, it is stored in a separate blob table.  This means that will be
necessary to generate and maintain separate indexes for searching
purposes.

Steve.