# Max number of tags in a single sql table

**URL:** <https://forum.inductiveautomation.com/t/max-number-of-tags-in-a-single-sql-table/73510>\
**Category:** Ignition\
**Created:** [May 10, 2023, 6:19am UTC](https://forum.inductiveautomation.com/t/max-number-of-tags-in-a-single-sql-table/73510 "2023-05-10T06:19:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![chaoliang](https://avatars.discourse-cdn.com/v4/letter/c/ba8739/32.png) [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\
**Post date:** [May 10, 2023, 6:19am UTC](https://forum.inductiveautomation.com/t/max-number-of-tags-in-a-single-sql-table/73510/1 "2023-05-10T06:19:32Z")

</div>

When using the sql bridge module/transition group, each tag will create a column in the data table.

If let's say there's one thousand tags, there will be 1001 columns in the same table.

If we need to store the values every 1 second, the number of values in the table will increase rapidly.

Is there a recommended max number of tags to be configured for each table?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [May 10, 2023, 11:31am UTC](https://forum.inductiveautomation.com/t/max-number-of-tags-in-a-single-sql-table/73510/2 "2023-05-10T11:31:09Z")

</div>

It is a DB limitation, typically.

Note that saving data every second this way is way less work for a DB than the equivalent with the tag historian. (One row per second with n+1 columns versus n rows per second with three occupied columns plus some nulls.)

---

<div class="post-metadata">

**Author:** ![chaoliang](https://avatars.discourse-cdn.com/v4/letter/c/ba8739/32.png) [@chaoliang](https://forum.inductiveautomation.com/u/chaoliang)\
**Post date:** [May 11, 2023, 1:03am UTC](https://forum.inductiveautomation.com/t/max-number-of-tags-in-a-single-sql-table/73510/3 "2023-05-11T01:03:49Z")

</div>

thanks for the reply.

Just googled about the database limit.

For postgres: 1600

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/a/7a95067faa48d5454dd90e7186a4f3c7d66d6e30.png)

For SQL Server: 1024  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/3/a3b60a17bce52c5ead946b72c3a166158960cac0.png)

For MySQL: 4096

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/0/c08aab4b86a3cc35a5bf1c5404c953d554b3085b.png)