I have a flow which triggers a bunch of 15-20 messages at the same time.
They all go through the same flow. And hit the mssql node.
I keep running into connect closed/ connection timeout from MSSSQL Plus node.
I have increased the connection pool to 50. But it doesnt help.
If i add a delay between the messages - then everything works .
Is this a know issue ?
Any recommendations how to overcome ?
If the only option is adding a delay - then any recommendations on delay time ?
Isnt 1st and 3rd option kind of same ?
(2nd option doesnt work for me - since i have different flows which need to do different things ).
Does this mean will be able to run only 1 transaction at a time ? irrespective of the number of flows i try to run in parallel ?
That would create for me at least serious performance issue with flows waiting at SQL node.