[mythtv-users] Slow MySQL query after delete

Larry K lunchtimelarry at gmail.com
Sat Nov 24 04:27:50 UTC 2007


What was your method to determine the duplicates?  And did you simply issue
a SQL delete to get rid of them, or some other mechanism?

On 9/6/07, crs23 <pvr at groundhog.pair.com> wrote:
>
>
>
> 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.
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20071123/292075c2/attachment.htm 


More information about the mythtv-users mailing list