I am developing a reporting web application using PHP/MySQL, and I believe every call to MySQL from PHP is a new session. The MySQL documentation that I read says that the query caching feature is only available in that session.
I tried Googling, but didn't get an answer to this, but is it possible to make query caching available across sessions, perhaps even in the next day? Alternatively, would there be any other way to cache my queries without writing the output to some physical table?