Caching Queries

BulldogGC

What are your guys opinions on the easiest way to cache queries?
Code snippets?

superwormy

Take result, put into an array, use serialize(), write to file

www.php.net/serialize

BulldogGC

Cache ... not output to a static file.
I'm talking about a CFM equiv. to a simple

<cachewithin=".3">

for say, 3 hours.

superwormy

Can't do it.
Or at least I don't know how :-)

All ColdFusion does to cache queries is store the result-set in RAM until it's needed again. I don't know if PHP alone could do this, because its just a scripting language, ColdFusion is a whole application server with all kindsa fancy intermediate stuff built in.

If you write the result-set to disk with PHP and work carefully on only caching the big slow queries, you can easily speed your application up by not hitting the database so much, especially on a site with a lot of traffic.

superwormy

Check out the pear::cache too, not sure if it'll help any...

http://translate.google.com/translate?hl=en&sl=de&u=http://www.ulf-wendel.de/projekte/cache/&prev=/search%3Fq%3DPEAR%2527s%2BUserland%2BCache%2Bbietet%2BIhnen%2Bmit%2Bwenigen%2BHandgriffen%2Beinen%2Bkleinen%2BPerformance%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8

http://pear.php.net

BulldogGC

I've been doing some thinking on the matter.
Perhaps a simple session ... set it once and only one session variable.

And if it's set don't run the queries again until the user closes the browser.

superwormy

In that case... you're writing the session to the disk anyways, why not just write the file to disk instead?

That way you might, depending on your application, be able to use that file over more than one session and save some more queries too.

Weedpacket

You could write some session handlers to use a database instead of files. That would cache results in core.

keith73

What database are you using?

I understand that postgres has query caching and I know MySQL 4 has query caching. If you use one of those databases, then you have another option.

keith