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.
