# 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:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![PRABHAKAR82](https://avatars.discourse-cdn.com/v4/letter/p/e47c2d/32.png) [@PRABHAKAR82](https://discourse.nodered.org/u/PRABHAKAR82)\
**Post date:** [17 January 2024 10:34 UTC](https://discourse.nodered.org/t/can-we-log-2000-tag-data-into-mysql/84638/1 "2024-01-17T10:34:05Z")

</div>

I am doing a ems projects in which 2000 tags I have to read and log tag data into MySQL. Is it possible to log 2000 tag data into MySQL from node-red without any issue?  
If any use case please suggest.

---

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [17 January 2024 11:08 UTC](https://discourse.nodered.org/t/can-we-log-2000-tag-data-into-mysql/84638/2 "2024-01-17T11:08:09Z")

</div>

> [@PRABHAKAR82](#):
>
> I am doing a ems projects ...

What is an ems project?

> [@PRABHAKAR82](#):
>
> ... in which 2000 tags I have to read and log tag data

What are these tags?  
Where are these tags?  
How much data does each provide?  
How often?

> [@PRABHAKAR82](#):
>
> Is it possible to log 2000 tag data into MySQL ...

Yes.

---

<div class="post-metadata">

**Author:** ![PRABHAKAR82](https://avatars.discourse-cdn.com/v4/letter/p/e47c2d/32.png) [@PRABHAKAR82](https://discourse.nodered.org/u/PRABHAKAR82)\
**Post date:** [17 January 2024 12:10 UTC](https://discourse.nodered.org/t/can-we-log-2000-tag-data-into-mysql/84638/3 "2024-01-17T12:10:09Z")

</div>

ems stand for Energy monitoring system.  
These tag have voltage,current, frequency, power factor data and log interval is 1min

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [17 January 2024 12:52 UTC](https://discourse.nodered.org/t/can-we-log-2000-tag-data-into-mysql/84638/4 "2024-01-17T12:52:33Z")

</div>

You CAN use Node-RED for this. Whether you _should_ is something that you will need to work out.

---

<div class="post-metadata">

**Author:** ![PRABHAKAR82](https://avatars.discourse-cdn.com/v4/letter/p/e47c2d/32.png) [@PRABHAKAR82](https://discourse.nodered.org/u/PRABHAKAR82)\
**Post date:** [17 January 2024 13:41 UTC](https://discourse.nodered.org/t/can-we-log-2000-tag-data-into-mysql/84638/5 "2024-01-17T13:41:42Z")

</div>

I doubt on performance of node-red when I will read and log 2000 tag on MySQ.I never added this quantity of tag in node-red.

---

<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!

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [17 January 2024 15:42 UTC](https://discourse.nodered.org/t/can-we-log-2000-tag-data-into-mysql/84638/7 "2024-01-17T15:42:47Z")

</div>

I know you have said mysql - but when you mention tags and the sort of data you mention - would a time series database like infuxdb be more appropriate ?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [31 January 2024 15:43 UTC](https://discourse.nodered.org/t/can-we-log-2000-tag-data-into-mysql/84638/8 "2024-01-31T15:43:43Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.