Another option is replace your direct DB calls with something that creates a ready-to-go presentation and keeps it cached in Cache::MemCached or such.
We do this for "events" pages on our pages and have found it to cut processing time by several orders of magnitude. If you have LOAD_PERL on your can use it directly from your template... or you can have a mod_perl handler do the lifting for you. On Sun, Aug 06, 2006 at 09:29:02PM -0400, Robert James Kaes wrote: > On Sun, 06 Aug 2006, Randal L. Schwartz wrote: > > >>>>> "Robert" == Robert James Kaes <[EMAIL PROTECTED]> writes: > > > > Robert> I'd like to say "the output of all components are cached. If a > > child > > Robert> component has changed, invalidate the child cache and its parent's > > Robert> cache." It would also be nice to selectively say "this component's > > Robert> output must never be cached." > > > > I've looked at this a number of times, and never gotten very far. If I may > > misquote Perrin, he's said something to the effect that the expense for > > determining when to blow a cache (and how much to blow) often exceeds the > > cost > > of just recomputing the darn thing. And yes, it's a can of worms. > > Thank you, you raise a good point that I had not fully considered. My > goal is to display a dynamically generated page, but where most of the > "dynamic" content is actually static for a period amount of time. (Take > a news page, for example, where the list of news stories updates once an > hour.) > > Having thought about the problem a bit more, I can likely simulate what > I'm looking for by using a template that INSERTs the "dynamic" content > that was generated by a cronjob periodically. This would move the heavy > DB processing offline relative to the page view. > > Randal, thank you for your insight! > > Have a great night. > -- Robert > > -- > Robert James Kaes > WormBytes Consulting and Contracting > http://www.wormbytes.ca/ > > _______________________________________________ > templates mailing list > [email protected] > http://lists.template-toolkit.org/mailman/listinfo/templates -- Todd Freeman Ext 6103 .^. Don't fear the penguins! Programming Department /V\ Andrews University // \\ http://www.linux.org/ http://www.andrews.edu/~freeman/ /( )\ http://www.debian.org/ ^^ ^^
signature.asc
Description: Digital signature
