I'm writing a web app in mod_perl, using a PostgreSQL database
backend and HTML::Template. In looking for ways to optimize
performance, I noticed that although my code is doing several
(say, 4-5) database queries per handler/webpage, a large part
of the data (~2 queries) is mostly static (it will change
perhaps once per week, or once per month). It's obviously
inefficient to run these queries on the database for every
single request.
How can I 'cache' this data so that all Apache children can
access it quickly? Is there a way to automatically update
this cache periodically (say every 10 minutes)? Also, this
solution should work on any reasonably modern UNIX system
(Win32 is not important for now).
I couldn't find this anywhere, but if someone tells me where,
I'd be happy to RTFM. Ask me if you need more info.
TIA,
Neil
--
Neil Conway <[EMAIL PROTECTED]>
Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc
Encrypted mail welcomed
"The superior man understands what is right;
the inferior man understands what will sell."
-- Confucius
