# Transaction group vs SQL Query **URL:** \ **Category:** Ignition\ **Tags:** ignition81, perspective\ **Created:** [April 13, 2024, 1:53am UTC](https://forum.inductiveautomation.com/t/transaction-group-vs-sql-query/88768 "2024-04-13T01:53:58Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Eagel007](https://avatars.discourse-cdn.com/v4/letter/e/7bcc69/32.png) [@Eagel007](https://forum.inductiveautomation.com/u/Eagel007)\ **Post date:** [April 13, 2024, 1:53am UTC](https://forum.inductiveautomation.com/t/transaction-group-vs-sql-query/88768/1 "2024-04-13T01:53:58Z")
Hi, I have 4 Tags. ComponentID (string), parameter 1, 2 and 3 (floats). My question is, Is Transaction group a better choice, with Trigger option on ComponentId Tag or A simple tag change script in componentID tag that ll pass parameters to SQL query which will insert record to the table. I guess both will serve the purpose but I am trying to understand if there are any key differences here. Thank you. ---
**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 13, 2024, 1:22pm UTC](https://forum.inductiveautomation.com/t/transaction-group-vs-sql-query/88768/2 "2024-04-13T13:22:36Z")
No functional difference in the end. Transaction groups provide a number of conveniences, though: - Drag and drop assembly of the items to record - Automatic table creation - Convenient timing and trigger options - Simple handshaking - Visual monitoring of behavior for troubleshooting Scripting has more _ **capability** _, especially for high-reliability handshaking, but you are otherwise on your own. ---
**Author:** ![Eagel007](https://avatars.discourse-cdn.com/v4/letter/e/7bcc69/32.png) [@Eagel007](https://forum.inductiveautomation.com/u/Eagel007)\ **Post date:** [April 13, 2024, 1:55pm UTC](https://forum.inductiveautomation.com/t/transaction-group-vs-sql-query/88768/3 "2024-04-13T13:55:03Z")
Thanks @pturmel @paul-griffith - any thoughts on this? Everyone please feel free to provide your experiences on this topic. Thanks . ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [April 13, 2024, 2:00pm UTC](https://forum.inductiveautomation.com/t/transaction-group-vs-sql-query/88768/4 "2024-04-13T14:00:58Z")
I recommend that you don't ping individual users looking for support. This isn't official support and is mostly staffed by volunteers although a couple of the IA engineers respond to a lot of questions. The good guys tend to read everything tagged with their areas of interest anyway. Just ask a good interesting question and you'll get answers. ---
**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 13, 2024, 2:47pm UTC](https://forum.inductiveautomation.com/t/transaction-group-vs-sql-query/88768/5 "2024-04-13T14:47:44Z")
> [@Transistor](#): > > don't ping individual users Concur. And consider doing some more of your own research, right here on this forum: [https://forum.inductiveautomation.com/search?q=transaction%20group%20vs%20order%3Alatest](https://forum.inductiveautomation.com/search?q=transaction%20group%20vs%20order%3Alatest) ---
**Author:** ![Eagel007](https://avatars.discourse-cdn.com/v4/letter/e/7bcc69/32.png) [@Eagel007](https://forum.inductiveautomation.com/u/Eagel007)\ **Post date:** [April 15, 2024, 2:50pm UTC](https://forum.inductiveautomation.com/t/transaction-group-vs-sql-query/88768/6 "2024-04-15T14:50:01Z")
Thanks for suggestions. I also have Upper and Lower limit for each parameter as individual tags and a Sepasoft SPC Module. what's your opinion on using Transaction Group vs Sepasoft SPC? Thanks ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [April 15, 2024, 3:00pm UTC](https://forum.inductiveautomation.com/t/transaction-group-vs-sql-query/88768/7 "2024-04-15T15:00:37Z")
IMO, the SPC module is for gathering samples, not for a 'continuous' process. ---
**Author:** ![Eagel007](https://avatars.discourse-cdn.com/v4/letter/e/7bcc69/32.png) [@Eagel007](https://forum.inductiveautomation.com/u/Eagel007)\ **Post date:** [April 15, 2024, 5:13pm UTC](https://forum.inductiveautomation.com/t/transaction-group-vs-sql-query/88768/8 "2024-04-15T17:13:19Z")
Basically its a sample collection only. However I would like to track component ID separately because they do marry with another component in the 2nd process. Thank you ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [April 15, 2024, 5:23pm UTC](https://forum.inductiveautomation.com/t/transaction-group-vs-sql-query/88768/9 "2024-04-15T17:23:14Z")
Assuming that these are all automatically gathered numbers, and the ComponentID is a serialized item, then I would collect data on all parts run through. Then, if-- or rather, when-- you need data on a specific component in any part of the process, you have it. Because if there is an issue in a process, it won't be in the sample parts. 😉