[mythtv-users] Re:Re:Slow EPG & cause info

[Tony Maro]

Brent W. York wrote:

>>The frontend issues dozens of quite complex SQL queries as you scroll 
>>around. Try switching on mysql query caching (if you have mysql 4) and 
>>you should notice a big speedup 
>>    
>>
>
>OK, I'm a real neophyte where SQL is concerned...so how you do dat?
>
>_Brent
>
>  
>
Well in Mandrake in my /etc/my.cnf file I added:

[mysqld]
query_cache_type=1
query_cache_size=5000000

And of course restarted MySQL.