Build a data base to hold a local temp version of the data from the remote
server. Then have a Scheduled Task run every minute or so to update your
local version of the data.
This should greatly speed up any page that relies on a query that could take
5 seconds.
You could also could also cache the data from the remote database in a
session var. Or look into query caching.
Mark W. Breneman
-Cold Fusion Developer
-Network Administrator
Vivid Media
[EMAIL PROTECTED]
www.vividmedia.com <http://www.vividmedia.com/>
608.270.9770
_____
From: applemicro [mailto:[EMAIL PROTECTED]
Sent: Monday, September 20, 2004 8:54 AM
To: CF-Talk
Subject: Coding question ?
I have a page that will display infromation from a remote database.
What i want to do is display the information from the remote database
but if the query to the remote database takes long then 5 sec I want
to abort the current query and query my local database which contains
a versions of the data but is 24 hours old
Thanks
Kurt
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
