# SQL Database and Tags **URL:** \ **Category:** Ignition\ **Created:** [February 26, 2020, 4:30pm UTC](https://forum.inductiveautomation.com/t/sql-database-and-tags/32634 "2020-02-26T16:30:55Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![amalric.sterlin](https://avatars.discourse-cdn.com/v4/letter/a/87869e/32.png) [@amalric.sterlin](https://forum.inductiveautomation.com/u/amalric.sterlin)\ **Post date:** [February 26, 2020, 4:30pm UTC](https://forum.inductiveautomation.com/t/sql-database-and-tags/32634/1 "2020-02-26T16:30:56Z")
Hi, I am working with a SQL database on Wampserver, and i am trying to save there some tags from the designer. I have approximately 10000 tags, could you tell me which is the best way to do it ? Tag History seems to not classify the tags, and Transaction Groups can’t handle big sets of data. thank you ---
**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:** [February 26, 2020, 4:36pm UTC](https://forum.inductiveautomation.com/t/sql-database-and-tags/32634/2 "2020-02-26T16:36:12Z")
> [@amalric.sterlin](#): > > Tag History seems to not classify the tags What do you mean by this? ---
**Author:** ![amalric.sterlin](https://avatars.discourse-cdn.com/v4/letter/a/87869e/32.png) [@amalric.sterlin](https://forum.inductiveautomation.com/u/amalric.sterlin)\ **Post date:** [February 26, 2020, 4:41pm UTC](https://forum.inductiveautomation.com/t/sql-database-and-tags/32634/3 "2020-02-26T16:41:13Z")
when i import different tags at the same time they are stored all mixed together in the same table i would like Ignition to create for me different tables, one for each tag or for selected tags ---
**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:** [February 26, 2020, 4:43pm UTC](https://forum.inductiveautomation.com/t/sql-database-and-tags/32634/4 "2020-02-26T16:43:27Z")
> [@amalric.sterlin](#): > > create for me different tables, one for each tag or for selected tags That's what transaction groups are. ---
**Author:** ![amalric.sterlin](https://avatars.discourse-cdn.com/v4/letter/a/87869e/32.png) [@amalric.sterlin](https://forum.inductiveautomation.com/u/amalric.sterlin)\ **Post date:** [February 26, 2020, 4:45pm UTC](https://forum.inductiveautomation.com/t/sql-database-and-tags/32634/5 "2020-02-26T16:45:33Z")
yes this is what i have understood but aren’t they limited to a low number of tags ? I tried with an increasing number of tags and around 40 tags the group won’t start running ---
**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:** [February 26, 2020, 4:55pm UTC](https://forum.inductiveautomation.com/t/sql-database-and-tags/32634/6 "2020-02-26T16:55:57Z")
That’s news to me. I have applications with a couple hundred columns–I don’t think there’s an arbitrary limit. Possibly just what your DB supports. It’s possible you have other issues, which would show up in your gateway logs. Like using the same column name twice in the same group. ---
**Author:** ![amalric.sterlin](https://avatars.discourse-cdn.com/v4/letter/a/87869e/32.png) [@amalric.sterlin](https://forum.inductiveautomation.com/u/amalric.sterlin)\ **Post date:** [February 27, 2020, 8:08am UTC](https://forum.inductiveautomation.com/t/sql-database-and-tags/32634/7 "2020-02-27T08:08:46Z")
Ok thank you very much ! The issue was indeed on the Target Name of the tags in the database, I was using the same name twice.