Page 1 of 1

odbc 3 times faster than native client ?

Posted: Tue 02 May 2017 11:30
by helinz
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

Re: odbc 3 times faster than native client ?

Posted: Fri 05 May 2017 13:14
by azyk
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