Caching query with $_SESSION?

[TitanKing]

Hi there, thanks for looking at my thread.

Quick question, would it be better caching a fairly complicated query inside a session rather then redoing the query on every page? The content stays fairly static and would only need to be re-cached on every login.

Any advice?

Regards...

[sneakyimp]

That depends on how you are handling sessions. I believe the default for PHP is to create little files in the tmp directory on your server. In high-traffic situations this can become a liability because the server's disk drive might be running back and forth reading little files.

On the other hand, your query is 'complicated' so putting it together might chew up a bunch of CPU time (and the queries might be gnarly too).

Are you talking about caching the sql or the results of the query?

[cgraz]

Cache the query results in a .php file using serialize() - not in a session.

[TitanKing]

Thanks for the replies guys, the serialize function is very interesting. I have found a mysql function called SQL_CACHE, this works for me for now. I will be playing around with Serialize...

Thanks for all the comments...