HI, So far all of 'my' queries work well but so far, I am having relatively low levels of demand. ie not a lot of traffic causing many queries. the tables are mostly innodb.
I read in another post about putting a table 'into memory' if there are to be many queries made on it so as (if I understand it), to redcue demand on the hdd. (presumably ram is cheaper than a hdd?)
But what does into memory mean? is it a table view? (I doubt it) and can anyhone show me a link so I can learn how to do it?