[mythtv-firehose] mythtv/fixes/0.24 commit: 1de043119 by Michael T. Dean (sphery)

MythTV noreply at mythtv.org
Mon Aug 29 23:27:17 UTC 2011

      Author:  Michael T. Dean <mdean at mythtv.org>
 Change Date:  2011-08-29T16:26:14-07:00
   Push Date:  2011/08/29 16:27:13 -0700
  Repository:  mythtv
      Branch:  fixes/0.24
New Revision:  1de043119cac1cdae3a418a5b4203a7fce58f514
   Changeset:  https://github.com/MythTV/mythtv/commit/1de043119


Fix inefficiency in marking first/last showings without programids.

For users without programids (where listings provider doesn't specify a
programid and doesn't specify both season and episode number),
mythfilldatabase marks first/last showings by comparing title, subtitle,
and description to find unique episodes.  If the listings provider
provides extremely long descriptions (>>255 characters), this results in
mysqld creating on-disk temp tables, and can create extremely long run
times for this specific query (with one user reporting times on the
order of 30min using an AMD Athlon II 5050e with 2GB RAM).

This change limits the query to use only the first 1024 characters of
description for the SELECT and the GROUP BY.  This is equivalent to what
we were doing before ccb759a946 changed the description from TEXT to
VARCHAR, since MySQL automatically uses max_sort_length (defaults to
1024) for sorting text and blob fields (including GROUP BY).  Even in
the event of 2 shows that differ only after the first 1024 characters of
the description, but that air at the same time, the logic is sound.  In
the event 2 shows with different start times that differ only after the
first 1024 characters of the description exist in the listings, one
won't be properly marked as first/last showing, but I'd hope that
listings providers would provide some indication of differences before
the end of the novel (but, again, this is the same behavior we would
have seen before the change to use VARCHAR for description).

Thanks to Jan Schneider for noticing the issue and performing a bunch of
test queries to help me find a way to work around it.
(cherry picked from commit 8b0daaf01f00605a424e95e55d0d62ab60827d70)



More information about the mythtv-firehose mailing list