Transaction group or query tag

Ignition
1

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

2

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.