<div dir="ltr"><div class="gmail_extra"><br><div class="gmail_quote">2012/12/30 Karl Dietz <span dir="ltr"><<a href="mailto:dekarl@spaetfruehstuecken.org" target="_blank">dekarl@spaetfruehstuecken.org</a>></span><br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
97 seconds just for finding all programs that MATCH your recording<br>
rules seems to be a bit much.<br>
<br>
Can you check that programs in the past get cleaned out?<br>
select * from housekeeping;<br>
Look if you have sane values for "lastrun".<br>
<br>
And verify that your database indices are intact. Just run the<br>
repair/optimize script for that.<br>
<a href="http://www.mythtv.org/wiki/User_Manual:Periodic_Maintenance#Optimize_the_Database" target="_blank">http://www.mythtv.org/wiki/User_Manual:Periodic_Maintenance#Optimize_the_Database</a><br clear="all"></blockquote>
</div><br></div><div class="gmail_extra">All the results from "select * from housekeeping;" are from today, or the last couple of days except<br><br>DBCleanup | 2010-03-20 21:38:15<br><br></div>
<div class="gmail_extra">don't know if this is a bad thing?<br><br></div><div class="gmail_extra">I optimize the db regularly (and ran both repair and optimize manually today), but it did not help.<br></div><div class="gmail_extra">
-- <br>Jarle Thorsen
</div></div>