Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
drman
Starting Member
38 Posts |
 Posted - 2003-08-28 : 12:20:46
|
| I create a recordset of up to 10000 records (or more in the future). I have to look up info on each on in a table that has grown to 2.5 million records. While going through the look up process, I get a timeout. Any suggestions on how to handle this???drman |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-28 : 12:37:15
|
| Change your timeout value. The default for most is 30 seconds. If you run the query in Query Analyzer, it will not timeout as the default is 0, which means never timeout. Timeouts are stored in different places, it just depends how you are connecting to SQL Server. How are you connecting to it?Tara |
 |
|
|
drman
Starting Member
38 Posts |
Posted - 2003-08-28 : 13:22:09
|
| I changed the settings on the server after I posted my initial request. It worked, however, I have to be able to speed it up considerably. I think the problem is in the actual queries into the 2.5 million records.Thanks muchdrman |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-08-28 : 13:34:13
|
| Can you post your DDL (CREATE TABLE scripts, Indexs etc) as well as teh query that you are running? We can help you tune your query and/or indexs.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2003-08-28 : 14:53:38
|
| also, how are you accessing these rows? are you bringing them all back into some application? which application are you using?- Jeff |
|
|
|
|
|
|
Recordset Timing out