For instance, we have a stored procedure that is called selectlists. When
the application is inialized, this procedure is called and sets all the
application varibles equal to the results. Because the data rarely changes,
its always keep in memory. Where we have dynamic content, new data is
entered all the time. You should use stored procedures, because they are
designed to effeciently request and recieve the data, on a real time basis.
-----Original Message-----
From: McCollough, Alan [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 30, 2000 3:08 PM
To: Fusebox
Subject: RE: refreshing cached queries
That depends (couldn't you see that coming?)...
Alan McCollough
Web Programmer
Allaire Certified ColdFusion Developer
Alaska Native Medical Center
> -----Original Message-----
> From: Chris Williams [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, October 30, 2000 2:18 PM
> To: Fusebox
> Subject: RE: refreshing cached queries
>
> How often does the info your using change?{redacted}
----------------------------------------------------------------------------
--
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.
