I'd always thought the query cache was more for one->few websites that were you could tune for, rather than being a catch-all bin for whatever gets run through the database. Does anyone know of ...

Probably a badly worded title, but we'll see where this goes...I have a reasonably large MySQL database (8GB MyISAM data, 1.2GB indexes) that holds statistical data. The data is inserted on a half ...