Re: Coding question ?

2004-09-20 Thread Andrew Grosset
If I had any process or query that took 5 seconds or more I would be extremely concerned. Hopefully someone with more database experience than I will respond to your enquiry. >I have a page that will display infromation from a remote database. >What i want to do is display the information from the

Re: Coding question ?

2004-09-20 Thread Thomas Chiverton
On Monday 20 Sep 2004 14:53 pm, applemicro wrote: > 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 que

Re: Coding question ?

2004-09-20 Thread Douglas Knudsen
- From: Andrew Grosset <[EMAIL PROTECTED]> Date: Mon, 20 Sep 2004 10:44:28 -0400 Subject: Re: Coding question ? To: CF-Talk <[EMAIL PROTECTED]> If I had any process or query that took 5 seconds or more I would be extremely concerned. Hopefully someone with more database experience than I

Re: Coding question ?

2004-09-20 Thread Douglas Knudsen
Thomas, this will leave a running thread on the sever though, eh?   Could be an issue especially when ling DB times are occuring. Doug - Original Message - From: Thomas Chiverton <[EMAIL PROTECTED]> Date: Mon, 20 Sep 2004 15:51:15 +0100 Subject: Re: Coding question ? To: CF-Talk &

RE: Coding question ?

2004-09-21 Thread Patrick McGeehan
AM To: CF-Talk Subject: Re: Coding question ? On Monday 20 Sep 2004 14:53 pm, applemicro wrote: > 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 lo

RE: Coding question ?

2004-09-21 Thread Mark W. Breneman
This is not exactly what you are looking for, but it may work better, 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 reli