<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<font color="black" face="Verdana,Arial,Helvetica" size="2"><font
color="black" face="Verdana,Arial,Helvetica" size="2">>>I run
contrib/optimize_mythdb.pl on a daily cron and <br>
>>(more importantly) before I start mythbackend on boot. <br>
>><br>
>>Paul Pick <br>
>>paul.pick[at]gmail.com <br>
<br>
</font></font>Thanks, Paul, that's exactly what I was looking for.<br>
<br>
I've updated the maintenance wiki to include it in periodic maintenance:<br>
<br>
<a class="moz-txt-link-freetext" href="http://www.mythtv.org/wiki/index.php/User_Manual:Periodic_Maintenance#Optimize_the_Database">http://www.mythtv.org/wiki/index.php/User_Manual:Periodic_Maintenance#Optimize_the_Database</a><br>
<br>
including some instructions from this thread:<br>
<br>
<a class="moz-txt-link-freetext" href="http://www.gossamer-threads.com/lists/mythtv/users/202318?search_string=optimize_mythdb;#202318">http://www.gossamer-threads.com/lists/mythtv/users/202318?search_string=optimize_mythdb;#202318</a><br>
<br>
<br>
</body>
</html>