Caching queries

[Anon]

Hi,

In coldfusion, there is the tag <cfcache> which will cache the results of a particular sql query. This is useful if you have, say, a search query that returns a list of results based on user input, and that list is too long to display on one screen. You break up the return results, and the user clicks on links to reload the page with different parameters to see different parts of the list (google or altavista are good examples). With cfcache, you run the query once and access the results many times without bothering the sql engine again. I haven't had to do this yet in PHP, but I soon might--how can one do it?

Chuck Shunk

[Anon]

You could obtain the same by using PHP 4's session features: Store the results in an array initially, make that array a session variable and then draw X number of search results per page.

[Anon]

If you are using templates in your scripts, then you could use something like CachedTemplates w/ the GET support and store cached documents from the queries.
Otherwise, there is not in-memory caching for results implemented in PHP or Apache itself. For that something like SQUID would be more effective and general.

HTH