|
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 7K
|
This would be on the SqlCommand, not the server timeout. So you would create the SqlCommand and set the timeout to a really high number or 0 for infinite.
However, let me suggest possible another route. Why would you need all 100,000 records at once? If you are trying to perform an incremental search, then you can create a threaded loader so that every time you type in a new character, it gets added to the queue, gets passed over to the server to s SPROC which executes the query, and sends back a TOP result set. Generally I limit my TOP results to 100 (or possible 1000) when I do something like this. This way you get a really fast, real-time search. To date, I have never needed or seen a reason for having 100,000 records client side.
|