Re: Persistent values between executions
| From: | Mike Mannakee | Date: | Mon, 10 Mar 2003 18:01:48 +0000 |
| Subject: | Re: Persistent values between executions | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-138985@lists.php.net to get a copy of this message | ||
Thanks, but what I need are static values accessible in the script, without
having to fetch them from the database every single page view. They do
occassionally change, but in the main they're fairly static.
Mike
"Rich Gray" <rich@f1central.net> wrote in message
news:KOENJGNHGACBDCEIKHKAMEHBEPAA.rich@f1central.net...
> >
> > I have some sets of values that I have stored in several tables in a
mySQL
> > database. These don't often change, but are referenced on every
> > single page
> > view. While each call is quick, as a gross the load on the server is
too
> > high. I would like to know if there is a way to have these sets of
values
> > remain persistent in the server's memory between calls from browsers,
like
> > environment variables, to reduce the back and forth calls to
> > mySQL. As the
> > data from the calls are almost always the same, it would seem easier
this
> > way.
> >
> > Any thoughts? Comments? RTFM suggestions?
> >
> > Mike
> >
> Use a 404 handler to build static html pages from the database. To refresh
> the content just delete the static content - this could be done
> automatically at predetermined intervals using cron or similar.
>
> FFT
> Rich
>