[mythtv] Any tv_grab_eu_epgdata users running master? (was Re: [mythtv-commits] mythtv/master commit: 8b0daaf01 by Michael T. Dean (sphery))

[Michael T. Dean]

On 08/27/2011 05:01 PM, MythTV wrote:
>        Author:  Michael T. Dean<mdean at mythtv.org>
>   Change Date:  2011-08-27T14:00:08-07:00
>     Push Date:  2011/08/27 14:01:21 -0700
>    Repository:  mythtv
>        Branch:  master
> New Revision:  8b0daaf01f00605a424e95e55d0d62ab60827d70
>     Changeset:  https://github.com/MythTV/mythtv/commit/8b0daaf01
>
> Log:
>
> 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).

I would love to backport this change to 0.24-fixes, but before doing so, 
would like a real-world sanity check from some users whose listings data 
results in mythfilldatabase hitting the changed code.

If you use tv_grab_eu_epgdata (and possibly radio times users--just 
please verify that you have a majority of programs without programid and 
your descriptions are long, max(length(description)) being somewhere 
 >1024 characters), I would very much appreciate your grabbing a 
mythfilldatabase log file before and after updating past this changeset 
and posting it for me to see

Thanks.

Mike