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
This is my problem. In the properties for editing the node, the parameters are not shown to me.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.