# Tag historian Vs transaction groups when storing data for OEE system

**URL:** <https://forum.inductiveautomation.com/t/tag-historian-vs-transaction-groups-when-storing-data-for-oee-system/94445>\
**Category:** General Discussion\
**Tags:** database, ignition81, perspective\
**Created:** [August 9, 2024, 7:31pm UTC](https://forum.inductiveautomation.com/t/tag-historian-vs-transaction-groups-when-storing-data-for-oee-system/94445 "2024-08-09T19:31:06Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [August 10, 2024, 12:44pm UTC](https://forum.inductiveautomation.com/t/tag-historian-vs-transaction-groups-when-storing-data-for-oee-system/94445/2 "2024-08-10T12:44:11Z")

</div>

Start here:

> [@SQL Tall/Long vs Wide Table Structure](https://forum.inductiveautomation.com/t/sql-tall-long-vs-wide-table-structure/26231/4):
>
> I generally make tables wide enough to permit related values to share a row in a table with a single timestamp column. This is the classic transaction group. If multiple entities share that specific structure, I include a column to indicate which entity to minimize the proliferation of tables. That would be the block transaction group, though I don’t usually use it – I prefer to trigger individual rows as needed. Both of these approaches are extremely friendly to external data analysis, but …

More discussions:

[https://forum.inductiveautomation.com/search?q=db%20tall%20wide%20order%3Alatest](https://forum.inductiveautomation.com/search?q=db%20tall%20wide%20order%3Alatest)

Also, keep in mind that anything that can be done with a transaction group can be done with scripted DB calls. This is particularly helpful when you need something for every instance of a UDT.

(But don't do SQL insert/update calls directly from a tag's `valueChange` event--use the Store and Forward versions.)

---

_[View the full topic](https://forum.inductiveautomation.com/t/tag-historian-vs-transaction-groups-when-storing-data-for-oee-system/94445)._