is get a record count quickly and if its larger then some threshold,
change where you look for the data. Certainly tune the SQL too :)
Andrew, when you work with large data sets, query times larger then 5
seconds happen frequently. For example, I had to write reports and
look ups against a table with more than 10 million rows and about 50
columns wide. Got them down to 10secs or less, but then pumping all
that data to a browser took forever. Sucked big blue monkey butt for
sure.
Doug
----- Original Message -----
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 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 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]
