[mythtv-users] Slow MySQL query after delete

[crs23]

Michael T. Dean wrote:
> 
> I don't think much testing has been done on systems having identical
> recording rules.  Though it shouldn't cause issues, cleaning out the
> duplicates (triplicates?  whatever) would significantly simplify the
> query's processing, so doing so would be very much to your advantage.
> 

Done and the improvement was substantial.  There were several multiple
entries.  One program had about a dozen duplicate entries and that just
happened to be the program with the most previously recorded episodes.  I
also changed the recordings to be on a particular channel instead of any
channel which I think helped to.

I'm now down to ~150,000 rows examined in 5.5 seconds, 696 rows returned.  5
or 6 seconds is hugely better but still a bit of an annoyance.  But I'm very
pleased with the results so far and the incredible support I've received on
this forum.  Thank you to everyone!

-- 
View this message in context: http://www.nabble.com/Slow-MySQL-query-after-delete-tf4366877s15552.html#a12534738
Sent from the mythtv-users mailing list archive at Nabble.com.