Can we log 2000 tag data into MySQL

Node-red is very capable. It all depends on how you do things.

For example, I have written demos where 5000 rows of SQL data were written to a SQL Server database in less than 3 seconds (proof) but if I had attempted to do them as 5000 separate inserts, it would have taken MUCH longer.

Another example: I have read over 1000 bytes of data from PLC and transformed it into object/array/parsed/named data. All less that 1 second (more like < 200ms). However, I read the 500 WDs (1000 bytes) in one transaction. Had I read 500 registers (tags) individually, it would probably have taken MUCH longer.

The point is, Node-RED is very capable in capable hands.

Or to say it another way, the quantity of "things" you are talking about are NOT extraordinary but your approach will be important!

3 Likes