# Best practice mssql node

**URL:** <https://discourse.nodered.org/t/best-practice-mssql-node/99386>\
**Category:** General\
**Created:** [14 October 2025 12:46 UTC](https://discourse.nodered.org/t/best-practice-mssql-node/99386 "2025-10-14T12:46:10Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [15 October 2025 09:32 UTC](https://discourse.nodered.org/t/best-practice-mssql-node/99386/6 "2025-10-15T09:32:18Z")

</div>

when you put a node like this (in a subflow) each instance of the subflow will create a separate connection to the database. If this is azure, you can easily hit connection limits.

You are better off using link-call as pointed out by @omrid

example: [Can Node Mssql running in many flow? - #5 by bakman2](https://discourse.nodered.org/t/can-node-mssql-running-in-many-flow/93954/5)

---

_[View the full topic](https://discourse.nodered.org/t/best-practice-mssql-node/99386)._