[mythtv-users] Running optimize_mythdb.pl before mythfilldatabase

[David Brodbeck]

Michael T. Dean wrote:
> Wouldn't it make sense to call mythfilldatabase first and then 
> optimize_mythdb.pl (since mfdb does a lot of deletes and then a lot of 
> inserts--it deletes all listings data for a given source for any day 
> that it updates and then puts in the whole days data).
>
> I guess you could argue that running mfdb on a corrupt database would be 
> bad, but since the table most likely to be corrupt is recordedseek 
> (which isn't touched by mfdb)...
>   

I suppose ideally you'd do the 'REPAIR TABLE' part before
mythfilldatabase, and the 'OPTIMIZE TABLE' part afterwards. ;)

Actually, strictly speaking, 'REPAIR TABLE' should never be necessary
unless you've had a power cut, overfilled disk, or other, similar
catastrophe.