[mythtv-users] Slow MySQL query after delete
crs23
pvr at groundhog.pair.com
Sat Nov 24 17:27:07 UTC 2007
I used MythWeb to both discover duplicates by inspection and delete them.
That took a long time because of the very problem I was trying to fix but
each deletion went faster than the last as the query got faster and faster.
A way to delete multiple recordings or recording rules at once would be nice
but I wasn't about to try deleting records directly from the database
because I don't know if that would cause some kind of inconsistency between
tables.
Larry K wrote:
>
> 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
>>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
--
View this message in context: http://www.nabble.com/Slow-MySQL-query-after-delete-tf4366877s15552.html#a13926650
Sent from the mythtv-users mailing list archive at Nabble.com.
More information about the mythtv-users
mailing list