For the queries I'm caching, once every 24 hours.
best, paul
At 03:17 PM 10/30/00 -0800, you wrote:
>How often does the info your using change?
>
>
>
>
>-----Original Message-----
>From: McCollough, Alan [mailto:[EMAIL PROTECTED]]
>Sent: Monday, October 30, 2000 3:01 PM
>To: Fusebox
>Subject: RE: refreshing cached queries
>
>
>Y'all aren't seeing the problem...
>
>When CF caches a query, no call to the db ever gets made!
>
>The problem is, how do you tell various nodes on a cluster to use CF-cached
>query results, or to execute a new query request to the DB?
>
>Alan McCollough
>Web Programmer
>Allaire Certified ColdFusion Developer
>Alaska Native Medical Center
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> > Sent: Monday, October 30, 2000 1:02 PM
> > To: Fusebox
> > Subject: RE: refreshing cached queries
> >
> > Stored procedures offer a resource independent solution to this problem.
> > If
> > your using cf to cached data your causing performance issues on your
> > webserver, but with stored proc's you not. It doesn't store the data in
> > ram
> > when you use stored procedures, just the execution plan. Which can
> > significantly improve query time execution. If you have the ram on your
> > webserver to support it, the best performance would be gained by using
> > stored proc's and then caching them as a session or application variable
> > on
> > the webserver, hence you get the best of both worlds.
> >
> > Rick
>----------------------------------------------------------------------------
>--
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>------------------------------------------------------------------------------
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
