This is what I would do...
- Read all bytes in one hit. This has 2 benefits -
- data is consistent (grabbed at same point in time)
- approximately 10 times faster than 11 individual polls
- use node-red-contrib-buffer-parser to convert data into Floats in one go (see screen shot below)
- (optional) use mssql-plus (beta version) and use typed parameters (see screen shot below)
Buffer Parser...
MSSQL-PLUS (beta version)...
Edit in case it's unclear...
The single flow at the bottom of the 1st screenshot replaces everything you did. I.e. if you use the 5 node flow I added, the 45 node flow you did becomes redundant/unneeded
