[mythtv-users] Slow MySQL query after delete
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
> pleased with the results so far and the incredible support I've received
> this forum. Thank you to everyone!
> View this message in context:
> Sent from the mythtv-users mailing list archive at Nabble.com.
> mythtv-users mailing list
> mythtv-users at mythtv.org
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users