[mythtv-users] Tip: Make the EPG a bit more snappy

[Edward Wildgoose]

This has been mentioned before, but I didn't give it too much notice the
first time, so here it is again:

If you have Mysql 4 then turn on query caching by adding a line like:

query_cache_size 4000000

to your /etc/mysql/my.cnf file

This gives the EPG in particular a noticable speed boost (and if you check
the mysql stats you can see that a lot of queries are satisfied from cache).

This seems to work because of the way the EPG checks each program to see
whether it is to be recorded or not.  The proper fix is to make this code
more efficient, but this seems like a partial workaround

Ed W