How can I run some code only once per day?

Hello,

I would like to be able to run a database query, but I only want the
query ran once per day. Then store the results from that query maybe
in a session or a cookie?

I want to do this in order to reduce the amount of database calls when
the page is refreshed.

Does anyone have any tips on how I could go about doing this? Here's
what I was thinking of doing:

When a user comes to the page for the first time I store the current
date and time and run the db query. Then if they try to access the
page again I compare that stored date and time to 24 hours ahead, if
its less I don't do the query I just run return the previous results,
if it's greater, then I run the query again and return the new
results. Is this a proper way to do it? Or is this check essentially
doing the same thing as running a new query anyways since it has to
check dates in the session/cookie?

Thanks.

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php