[mythtv-users] 0.25 SQL CPU Load issues after optimisation

[Another Sillyname]

On 19 July 2012 20:33, Gary Buhrmaster <gary.buhrmaster at gmail.com> wrote:
> On Thu, Jul 19, 2012 at 3:10 AM, Another Sillyname
> <anothersname at googlemail.com> wrote:
> ....
>> Thanks for this but didn't help I'm afraid.
>
> It might be interesting to take the select, and run it
> under an EXPLAIN (perhaps an extended explain)
> to see what might be the cause of (what sounds like)
> a table scan.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users

I'm trying to reverse engineer the SQL command that appears to be the
trigger/cause of the the problem but I'm beyond the limit of my
skillset on SQL here.  It would be very helpful if either one of the
devs or a SQL guru stepped in here to help look at this.

I don't believe I'm the only person suffering with this problem but
due to the nature of the fault 'clearing' itself other people may not
even be aware they're suffering with it.

If a few people run the script I posted it would be interesting to see
the results.

I run a combined UK Freeview and Freesat installation.