odbc 3 times faster than native client ?

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
helinz
Posts: 1
Joined: Sat 10 Oct 2015 15:08

odbc 3 times faster than native client ?

Post by helinz » Tue 02 May 2017 11:30

Hello,
i use Delphi XE and SDAC 6.10 (but i tried it also with 8.0): queries with provider = prSQL performs around 3 times faster than with provider = prNativeClient. And this with different nativeClient-versions and different ODBC-versions...
But 'Encrypt' and 'NonBlocking'(TMSSQL) needs nativeClient.
Has somebody the same experience or am i doing something wrong?

Thanks,
Helmut

azyk
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: odbc 3 times faster than native client ?

Post by azyk » Fri 05 May 2017 13:14

Please compose a small project which demonstrates the specified performance difference and send it for investigation. To send the project use the contact form at our site: http://www.devart.com/company/contactform.html .

Also specify the exact version of OLEDB provider and SQL Native Client provider. You can see it the Info sheet of TMSConnection Editor

Post Reply