Commencer un nouveau sujet
Répondu

Mapping reading MSSQL source is slow

Hello,


We have a mapping with MS SQL source which is very slow.


But, when we execute SQL generated by xDI on an SQL editor like DBeaver or SQL Server we have a good response time.


How to get a better response time on xDI ?


Meilleure réponse

Three-point to check : 


Check if the module was default and therefore used the jdbc in the default module and prefer to use sqlserver module instead. 


 

Add sendStringParametersAsUnicode=false parameter in the jdbc url parameter


 

Removed the SelectMethod=cursor still in the jdbc url.


1 commentaire

Réponse

Three-point to check : 


Check if the module was default and therefore used the jdbc in the default module and prefer to use sqlserver module instead. 


 

Add sendStringParametersAsUnicode=false parameter in the jdbc url parameter


 

Removed the SelectMethod=cursor still in the jdbc url.


Connexion pour poster un commentaire