[mythtv] SELECT where RecordChanged... once a second

[Kirby Vandivort]

> > (
> > Another suggestion for those of you running mysql 4+..  Turn on caching.
> > It can effectively prevent disk hits for those selects..  Add something
> > like:
> > 
> > # set the cache to 8 megs
> > query_cache_size = 8M
> > query_cache_type = 1
> > 
> > to your [mysqld] section of my.cnf.
> > )
> 
> For those of us with a spare 4k or so of memory that can be used for disk
> cache, this will always be in memory anyway.  The only disk hit would be for
> writing the query log (if enabled).  Does this configuration change prevent
> the query from being logged either?

Sadly, no.  


-- 

Kirby Vandivort                      Theoretical and Computational Biophysics 
Email: kvandivo at ks.uiuc.edu          3051 Beckman Institute
http://www.ks.uiuc.edu/~kvandivo/    University of Illinois
Phone: (217) 244-5711                405 N. Mathews Ave
Fax  : (217) 244-6078                Urbana, IL  61801, USA