How can I change mssql connection timeout value?

[vi-rgaigl]

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.

[ScheepersJohan]

@vi-rgaigl

node-red-contrib-mssql-plus

Welcome @vi-rgaigl to the forum

Are there a specific reason you use this node?

[vi-rgaigl]

thank you for the quick reply
No.
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?

[Steve-Mcl]

@ScheepersJohan

Are there a specific reason you use this node

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

[vi-rgaigl]

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

[Steve-Mcl]

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