# Transaction group vs query tag - re: resource utilization **URL:** \ **Category:** Ignition\ **Tags:** scripting, database, ignition79\ **Created:** [March 15, 2018, 6:17pm UTC](https://forum.inductiveautomation.com/t/transaction-group-vs-query-tag-re-resource-utilization/17380 "2018-03-15T18:17:17Z")\ **Posts on this page:** 1\ **Showing post:** 3
**Author:** ![AIO](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/aio/32/87549_2.png) [@AIO](https://forum.inductiveautomation.com/u/AIO)\ **Post date:** [May 19, 2020, 4:35pm UTC](https://forum.inductiveautomation.com/t/transaction-group-vs-query-tag-re-resource-utilization/17380/3 "2020-05-19T16:35:19Z")
While I've not received a specific answer to this query, last consensus was that only updating when data had changed was optimal, using either a tag change script or a gateway script to manage it. Here's the latest thread that touched these queries. > [@\[bug-15464\]Query Tags running Update statements execute but display as errored](http://forum.inductiveautomation.com/t/bug-15464-query-tags-running-update-statements-execute-but-display-as-errored/30007/5): > > While I don’t disagree with Phil about unconditional updates to the DB, this is actually supported - there’s code on the backend to attempt to determine the query type, and issue it to the db as an update/select appropriately- and there’s also a manual query type override, that we’re just not exposing in the UI - I’m not sure why. @AIO, I can’t guarantee this will work, but if you right click the tag, select ‘Edit (raw)’, and then add a queryType: Update property, do you still get the error on … --- _[View the full topic](https://forum.inductiveautomation.com/t/transaction-group-vs-query-tag-re-resource-utilization/17380)._