Yeah that was it....
But you could probably even use Memoize for somehting like this?
>-----Original Message-----
>From: Peter Haworth [mailto:[EMAIL PROTECTED]]
>Sent: Friday, November 03, 2000 12:43 PM
>To: Jerrad Pierce; 'Neil Conway'; ModPerl List
>Subject: RE: dynamic vs. mostly static data
>
>
>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
>
>