July 22, 2004 at 3:16 am
Hi Guys... whats up... got a problem here...
I Have 3.6 million of records in 2 tables... and when i retrieve those records i ussually get the message Time Out Expires. I already adjust my connection timeout to "0 = Unlimited Time" but still time out expires. Guys do you have an idea how i solve this problem....
Thanks In Advance!!!
DROP THE ZERO AND GIVE IT TO THE HERO...ZEROCOOL
July 22, 2004 at 8:13 am
Do you know who is timing you out? (server side, client side, etc.) What tool are you using to retrieve the records?
July 23, 2004 at 5:56 am
What version of SQL Server? What is the query causing the error? And why are you trying to retrieve 3.6 million records? Are you allowing dirty reads on the table(s)?
July 23, 2004 at 1:33 pm
Are you trying to pull back all 3.6 million records? If not check your indexes for sure. As the guy above said you may want to issue a nolock hint to keep it from being blocked.
Wes
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply