# What is the best way to store data?

**URL:** <https://forum.inductiveautomation.com/t/what-is-the-best-way-to-store-data/80374>\
**Category:** Ignition\
**Created:** [October 12, 2023, 5:17am UTC](https://forum.inductiveautomation.com/t/what-is-the-best-way-to-store-data/80374 "2023-10-12T05:17:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ignitionSL](https://avatars.discourse-cdn.com/v4/letter/i/9e8a1a/32.png) [@ignitionSL](https://forum.inductiveautomation.com/u/ignitionSL)\
**Post date:** [October 12, 2023, 5:17am UTC](https://forum.inductiveautomation.com/t/what-is-the-best-way-to-store-data/80374/1 "2023-10-12T05:17:47Z")

</div>

Is it through the transaction group or Tag's history?  
Looking for comprehensive explanation.

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

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

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [October 12, 2023, 6:32am UTC](https://forum.inductiveautomation.com/t/what-is-the-best-way-to-store-data/80374/2 "2023-10-12T06:32:36Z")

</div>

Some old discussion:

- [Transaction Groups vs SQLTag Historian - #2 by Travis.Cox](https://forum.inductiveautomation.com/t/transaction-groups-vs-sqltag-historian/5429/2)

Some user manual info:

- [Tag Historian - Ignition User Manual 8.1 - Ignition Documentation](https://docs.inductiveautomation.com/display/DOC81/Tag+Historian)
- [SQL Bridge (Transaction Groups) - Ignition User Manual 8.1 - Ignition Documentation](https://docs.inductiveautomation.com/pages/viewpage.action?pageId=58597803)

---

<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:** [October 12, 2023, 12:33pm UTC](https://forum.inductiveautomation.com/t/what-is-the-best-way-to-store-data/80374/3 "2023-10-12T12:33:24Z")

</div>

Quite a few discussions about this on this forum, using other keywords:

[https://forum.inductiveautomation.com/search?q=table%20tall%20wide](https://forum.inductiveautomation.com/search?q=table%20tall%20wide)

Quite comprehensive. (There's not just one answer for all applications.)

---

<div class="post-metadata">

**Author:** ![Ryan\_Allen](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan_allen/32/47013_2.png) [@Ryan\_Allen](https://forum.inductiveautomation.com/u/Ryan_Allen)\
**Post date:** [October 13, 2023, 12:57am UTC](https://forum.inductiveautomation.com/t/what-is-the-best-way-to-store-data/80374/4 "2023-10-13T00:57:50Z")

</div>

Transaction groups are very helpful for reporting, I'll say that. I've managed to make it work well enough with the standard historian to avoid the added cost of the SQL Bridge module though.