I've been really starting to use mythtv to its fullest. We are really enjoying it, but - it is a known problem that the program guide data does not stay populated. I have looked at mythfilldatabase.sh and MythTVDailyFillDB.sh. I have been manually running mythfilldatabase.sh every day to keep my guide data current, but I am noticing several problems.
- it takes anywhere from 6-8 hours for mythfilldatabase to run. During this time Top shows CPU usage from 80%-90% on mysqld (due to the number of database operations). My entire LMCE setup lags terribly during this time.
- it appears to download and resync the entire 14 days worth of guide data (over 600 channels worth at that) each time I run it. I would have figured it would only download and add to the database only the days it needs to be 14 days ahead.
So - while I'm enjoying the mythtv experience, I really wish there was a better way than manually running a script every day that takes up 6-8 hours while lagging my entire system. Also to note, the system is of very capable specs (BE2400 CPU, 4 gig RAM) so why its bogging me down so bad is a mystery to me.
Is there a more elegant solution? This is just the beginning of my mythtv experience, so I'm a little ignorant on the subject. Any help would be appreciated.