I have a project coming up where one of the requirements will be to cache what's essentially read-only data in order to lessen the strain on the db. I'm just a bit confused on how caching works with a db.
How does caching work? I've seen something called query caching, but does that cache query results? Or just the queries? And isn't a view a form of caching anyway?
I'm just looking for a nudge in the right direction. The project will use MySQL 5.1 for the store, so any links that can clear up my confusion would be a big help. A general Google search has only provided me with query caching, and with my lack of knowledge in this area, I'm not sure if that's the direction I should go.