SQL Server OLE DB - performance tweaks

General discussion forum about all databases other than SqlBase.
User avatar
Steve Leighton
Site Admin
Site Admin
New Zealand
Posts: 288
Joined: 05 Mar 2017, 20:57
Location: Tauranga, New Zealand <--> Stroud, England

SQL Server OLE DB - performance tweaks

Post by Steve Leighton » 04 Jul 2019, 03:41

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.
Greetings from New Zealand
Steve Leighton

Bankside Systems Ltd.
UK ♦ Australia ♦ New Zealand

www.banksidesystems.co.uk

Image

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests