How can I change mssql connection timeout value?

General
1

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.

2

Welcome @vi-rgaigl to the forum

Are there a specific reason you use this node?

3

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?

4

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

image
image518Ă—575 15.5 KB

5

Node mssql properties
Node mssql properties500Ă—960 13.7 KB

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

6

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