OleDb slower than SQL Native #xpa #oledb #sql #performance


Leandro Machado
 

Is there any way for Magic xpa to use a native SQL Server connection instead of OleDb?
For example, 20 queries with a OleDB SQL connection takes 18s, while  same 20 Native SQL connection takes 10s (same query, same amount of records, same machine, same network, etc.).

Thanks.