odbc 3 times faster than native client ?
Posted: 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
			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