I am using the MS SQL Server node to Insert data into a database. However, the dataset is moderately large (± 10.000 records) which caused the query to take more than 15.000 ms.
In order to fix this I set the ‘Connect Timeout’ in the Credential of the MS SQL Server to 300.000 ms:
However, when I execute an SQL Server node with the Insert operation I still get the error that the 15.000 ms are exceeded:
Any tips on how to solve this?