Re: forced caching of volatile data

2003-08-14 Thread Upayavira
On 10 Aug 2003 at 22:26, Geoff Howard wrote: rufio wrote: Hi all Is there a way to enfoce an asumption that volatile data (eg. stored in DB) changes once a specific interval? Now if we have 100 requests/s SQLTransformer querys DB 100 times/s, right? I'd like to set it up to query

forced caching of volatile data

2003-08-14 Thread rufio
Hi all Is there a way to enfoce an asumption that volatile data (eg. stored in DB) changes once a specific interval? Now if we have 100 requests/s SQLTransformer querys DB 100 times/s, right? I'd like to set it up to query only once a, say minute and cache the result. Regards, Rufio

Re: forced caching of volatile data

2003-08-14 Thread Geoff Howard
rufio wrote: Hi all Is there a way to enfoce an asumption that volatile data (eg. stored in DB) changes once a specific interval? Now if we have 100 requests/s SQLTransformer querys DB 100 times/s, right? I'd like to set it up to query only once a, say minute and cache the result. To my knowledge

Re: forced caching of volatile data

2003-08-14 Thread Geoff Howard
Miles Elam wrote: I'm doing this from memory so bear with me. I'm pretty sure this is the syntax in the sitemap pipelines section. map:pipeline type=caching map:parameter name=expires value=access plus 1 minutes/ !-- Add your URI matchers below that you want to expire in the

Re: forced caching of volatile data

2003-08-11 Thread rufio
on Mon, 11 Aug 2003 02:45:29 + Steve Schwarz [EMAIL PROTECTED] wrote: You might want to talk to your DBA about how your database handles caching. Properly tuned if all this SQL activity is really all selects (and all the same set of selects) the DBMS shouldn't even hit the disk - all the