Developer forum

Forum » Integration » Performance DataIntegration module when SSL is enabled on SQL Server

Performance DataIntegration module when SSL is enabled on SQL Server

Ben Doorn
Reply

Does anyone else experienced a huge performance drop in dataintegration when enabling SSL connections on the SQL server? And knows a solution to fix it?

We have an integration that ran in about 15 minutes, after enabling SSL connections on SQL, the performance drops about 16 times to 4+ hours. (for less then 4000 products in 6 languages)

Of course there is some overhead when using SSL so a little drop in performance was expected, but this is way more than expected.

 


Replies

 
Dynamicweb Employee
Dmitriy Benyuk
Reply

Hi Ben,
could you give more details what Data Integation job is used? Source and Destination providers? Are you sure that the same job is executed in both scenarios?
Kind regards, Dmitrij

 

You must be logged in to post in the forum