SQL Server Performance Forum – Threads Archive
cannot open Large Table with Image fieldsi have one table with this structure
FileContent Image this table have 500,000 record. i want open it. but i cannot open it and timeout. With rstFilesContent
.ActiveConnection = CnOffice
.CursorLocation = adUseServer
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Source = "Select * From FilesContent Order By FileID"
.Properties("preserve on commit") = True
.Properties("preserve on abort") = True
Cursortype must be keyset becuase i use move function
You are retrieving 500,000 rows with images ???
Looks pretty much like a connection or commandtimeout in ADO.
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx might be interesting