How can I change mssql connection timeout value?

I have a database query that takes about 90 seconds (database very large and complex query with many joints).
I always run into a connection timeout of 15000 ms with the mssql node. How can I change the value?

I use node-red-contrib-mssql-plus : MSSQL v0.7.3.

I already tried to export the node and import the changed JSON again. It did not work.

Welcome @vi-rgaigl to the forum

Are there a specific reason you use this node?

thank you for the quick reply
With the node-red-contrib-mssql v0.0.7 node it didn't work either, so I thought it might be possible with the node.
Or is there basically another way to do MS database queries?

Its the most up-to-date, has most features and is most supported (by me).

@vi-rgaigl the correct fix is to have the DBA to restructure data and/or add indexes to speed up the query. Otherwise, you can change the timeout in the config node

1 Like

This is my problem. In the properties for editing the node, the parameters are not shown to me.

Uninstall node-red-contrib-mssql
Install node-red-contrib-mssql-plus
Refresh browser.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.