smchamberlin / node-red-contrib-ibm-db2

Node-RED nodes to work with a Db2 LUW database. Works with "Db2 on Cloud" and "Db2 Warehouse on Cloud" services as well as standalone installation of Db2 LUW.
4 stars 14 forks source link

One connection per SQLDB node #2

Open WilliamBradee opened 8 years ago

WilliamBradee commented 8 years ago

Each node added to the flow creates an sqldb connection at Node-RED deployment time. In Bluemix, there's a limit of 10 connections, so the node can quickly exhaust the limit if used liberally. Expected behavior - one connection multiplexed among all nodes. Or a connection set up/torn down for each transaction.