# Can we log 2000 tag data into MySQL

**URL:** <https://discourse.nodered.org/t/can-we-log-2000-tag-data-into-mysql/84638>\
**Category:** General\
**Created:** [17 January 2024 10:34 UTC](https://discourse.nodered.org/t/can-we-log-2000-tag-data-into-mysql/84638 "2024-01-17T10:34:05Z")\
**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:** [17 January 2024 13:57 UTC](https://discourse.nodered.org/t/can-we-log-2000-tag-data-into-mysql/84638/6 "2024-01-17T13:57:04Z")

</div>

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](https://github.com/bestlong/node-red-contrib-mssql-plus/issues/35#issuecomment-679396761)) 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!

---

_[View the full topic](https://discourse.nodered.org/t/can-we-log-2000-tag-data-into-mysql/84638)._