# Queries, Transaction Groups or something else?

**URL:** <https://forum.inductiveautomation.com/t/queries-transaction-groups-or-something-else/114682>\
**Category:** Ignition\
**Tags:** vision, ignition81\
**Created:** [March 25, 2026, 9:00pm UTC](https://forum.inductiveautomation.com/t/queries-transaction-groups-or-something-else/114682 "2026-03-25T21:00:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mdemaris](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mdemaris/32/54639_2.png) [@mdemaris](https://forum.inductiveautomation.com/u/mdemaris)\
**Post date:** [March 25, 2026, 9:00pm UTC](https://forum.inductiveautomation.com/t/queries-transaction-groups-or-something-else/114682/1 "2026-03-25T21:00:56Z")

</div>

Hi all,  
we have a machine with about 80 individual Positions; each position can belong to a larger logical area called a Zone.

I am attempting to record multiple datapoints per Position and per Zone on a button click event. Currently I have Transaction Groups ready for the Zone data, but as I look at the Positions, I am not so sure TGs are the way to go. The data tables store one row per Zone or per Position, which means I need one TG per Zone and one TG per Position. Which means like 100 TGs all firing from one trigger tag.

Does this seem like a good way to go about this? If there are better, more efficient ways, what are they?

thanks,  
Mike

---

<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:** [March 25, 2026, 9:02pm UTC](https://forum.inductiveautomation.com/t/queries-transaction-groups-or-something-else/114682/2 "2026-03-25T21:02:55Z")

</div>

This should be scripted. You will probably also want to construct a multi-row prep insert to minimize the round trips to the database.