[mythtv-firehose] mythtv/master commit: d9fb21853 by Michael T. Dean (sphery)

MythTV noreply at mythtv.org
Wed Sep 7 10:59:00 UTC 2011

      Author:  Michael T. Dean <mdean at mythtv.org>
 Change Date:  2011-09-07T03:58:08-07:00
   Push Date:  2011/09/07 03:58:54 -0700
  Repository:  mythtv
      Branch:  master
New Revision:  d9fb21853f6a924a9881750a3e89868da7278214
   Changeset:  https://github.com/MythTV/mythtv/commit/d9fb21853


Add indices on subtitle/description in program/oldrecorded

Add some indices on subtitle and description columns in program and
oldrecorded tables.  These should help with both mythfilldatabase's
first-/last-showing marking step and scheduler performance.

Because the description column allows extremely long text values, the
index for the description columns uses a prefix length of 255
characters.  This prefix length fits within the engine-specific maximum
prefix length for both MyISAM (1000 bytes) and InnoDB (767 bytes) for a
UTF-8 column (meaning up to 3 bytes per character).  Therefore, the
index will work properly after we convert to InnoDB without being
silently changed.

Note: This update may take a while, especially for users with a long
descriptions in listings data.



More information about the mythtv-firehose mailing list