There is a query caching module someone posted here redently...
Or was it proposed and beta-ish?
Another thing you might consider doing is having a cron job do your periodic
(10 min.)
fetch and store it as a file somewhere... Then use SSI or some more
mod_perl-ish means of including this static content...
>-----Original Message-----
>From: Neil Conway [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, November 02, 2000 4:45 PM
>To: ModPerl List
>Subject: dynamic vs. mostly static data
>
>
>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
>
