bestlong / node-red-contrib-mssql-plus

A Node-RED node to read and write to Microsoft MS SQL Databases
MIT License
31 stars 18 forks source link

New connection per node? #26

Closed NeltherGP closed 4 years ago

NeltherGP commented 4 years ago

I want to know if a new connection is created for each node or if a single connection is shared between many nodes.

bestlong commented 4 years ago

this package have two node. MSSQL node and MSSQL-CN node. MSSQL node for query MSSQL-CN for connection pool many MSSQL node can use common MSSQL-CN node.

NeltherGP commented 4 years ago

Thanks, I confirmed this with sp_who2 query and executing a test sp with a delay inside.