odbc 3 times faster than native client ?

[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

[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