I have a big flow with 17 "functional flow lines" that do the same but with different payloads.
One part of that is working on a Database. Reading here, writing there and so on.
The Flow is updated everty 1.2 seconds and my Connection Count on the database sums up.
Is there a way to acess one "node-red-node-mysql" from multiple flow positions with different payloads and orders?
atm i use 2 SQL nodes per line, thats 34 Connections only from that part. It is a Company DB and that is to much. I have to leave Connections to other colleagues.
Friday i reached the max Connection Count for that db.