If your loading application variables equal to a db query, it is absolutley
faster to call a stored proc to access the data and set the result equal to
a variable than it is to use a cfquery. Either way the database has to be
called, and the stored procedure will have a hefty head start with the query
plan already in memory. And in both cases, remeber the data ends up in
memory.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 30, 2000 2:28 PM
To: Fusebox
Subject: RE: refreshing cached queries
I would use client variables in place of my application/session variable
idea. Don't see why that wouldn't work.
Rick
-----Original Message-----
From: McCollough, Alan [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 30, 2000 5: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.
