It might have been my Cache::Mmap module, which is ideal for this kind of
thing. It depends on what your data looks like though, of course.
On Thu, 2 Nov 2000 16:48:24 -0500 , Jerrad Pierce said:
> 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.
--
Peter Haworth [EMAIL PROTECTED]
"Writing for a penny a word is ridiculous. If a man really wants to make
a million dollars, the best way would be to start his own religion."
-- L. Ron Hubbard