# Transaction group or query tag

**URL:** <https://forum.inductiveautomation.com/t/transaction-group-or-query-tag/71983>\
**Category:** Ignition\
**Created:** [April 3, 2023, 7:37pm UTC](https://forum.inductiveautomation.com/t/transaction-group-or-query-tag/71983 "2023-04-03T19:37:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![schen48](https://avatars.discourse-cdn.com/v4/letter/s/67e7ee/32.png) [@schen48](https://forum.inductiveautomation.com/u/schen48)\
**Post date:** [April 3, 2023, 7:37pm UTC](https://forum.inductiveautomation.com/t/transaction-group-or-query-tag/71983/1 "2023-04-03T19:37:57Z")

</div>

we have an event based table in production, it includes start time and end time column. the events are from different locations. it is simple to query what is the most recent event for each location. it can be done to use either db to opc transaction group or some query tag. I am wondering is there any performance or other different for both options?

Thank you

---

<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:** [April 3, 2023, 7:44pm UTC](https://forum.inductiveautomation.com/t/transaction-group-or-query-tag/71983/2 "2023-04-03T19:44:34Z")

</div>

If you need to populate multiple OPC tags from the result, the transaction group would be the only drag-n-drop solution. With a query tag, you would have to script the distribution of the result dataset contents to tags.