Well, that sounds likely. I have not had much db experience, so<br>I did not know about the indexes. I'll look into how to index, and<br>into the EXPLAIN command.<br><br>Y'know, I am learning a lot about databases with mythtv, and its<br>
very applicable to certain parts of my job. This just proves that<br>TV is good for your mind. ;)<br><br>Thanks, Pat<br><br><div class="gmail_quote">On Fri, Nov 14, 2008 at 8:29 PM, Matthew McClement <span dir="ltr"><<a href="mailto:mythtv@macker.co.uk">mythtv@macker.co.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Pat Pierce wrote:<br>
*snip*<br>
<div class="Ih2E3d">><br>
> was being left at "0" when the system deleted the files out of the<br>
> "deleted" group. After updating the table with "update oldrecorded<br>
> set duplicate='1';", I decided to clean up all the duplicate entries<br>
> in the table. I had several hundred<br>
><br>
> lines which were duplicate title and subtitle, so I copied the table<br>
> to "oldrecorded_test" create table oldrecorded_test as select * from<br>
> oldrecorded; and made a delete statement as follows: delete from<br>
> oldrecorded_test T1 where starttime not in<br>
</div>*snip*<br>
<br>
Unless I'm missing something, it doesn't look like you re-created the<br>
indexes on the new table, so selects were likely resulting in a full<br>
table scan.<br>
<br>
Depending on how much time you have, you can usually figure out what's<br>
causing the performance problems by turning on slow query logging in<br>
MySQL and then running the queries manually, prefixed with EXPLAIN. The<br>
output isn't hugely complicated but the manual is your best reference to<br>
figuring out the<br>
output(<a href="http://dev.mysql.com/doc/refman/5.0/en/using-explain.html" target="_blank">http://dev.mysql.com/doc/refman/5.0/en/using-explain.html</a>).<br>
<br>
Matt<br>
<div><div></div><div class="Wj3C7c"><br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
</div></div></blockquote></div><br>