Did you indexed by any key field in the table?
-----Original Message-----
From: Joseph Vincent [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 24, 2000 7:15 AM
To: CF-Talk
Subject: large database query timing out
I am running a rather large database query that is supposed to retrieve
42,000 records through ODBC...however, the operation only retrieves about
19,000 before it times out. Is there anywhere that I can change a setting
in Administrator that will allow the query to work for a longer period of
time?
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
