SQL Server OLE DB - performance tweaks

[Steve Leighton]

If you are struggling with performance reading in large result-sets via SQL Server OLE DB, and assuming your indexes are all set, I have found the following HUGELY improved things.
No doubt, not all will agree, but here's a suggestion you could try:

In your connection string try adding one or both of the following settings:

;CLIENTCURSOR=TRUE;SSPROP_INIT_PACKETSIZE=8192

I couldn't believe the difference in response times.

[RainerE]

Hi Steve,

"Extended Properties="CLIENTCURSOR=TRUE;" will increase performance,yes.
But I had problems with large recordsets and decided to remove this setting, which I had added because of your hint.
See thread viewtopic.php?f=6&t=73639 for details.

Rainer