# Transaction execution delay **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [March 14, 2025, 5:24pm UTC](https://forum.inductiveautomation.com/t/transaction-execution-delay/103718 "2025-03-14T17:24:33Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\ **Post date:** [March 14, 2025, 5:26pm UTC](https://forum.inductiveautomation.com/t/transaction-execution-delay/103718/2 "2025-03-14T17:26:41Z")
Post code, not pictures of code. It helps to speed up responses by letting people copy and paste instead of reading and typing. Please see [Wiki - how to post code on this forum](https://forum.inductiveautomation.com/t/wiki-how-to-post-code-on-this-forum/77831). You can edit your post by clicking the pencil icon in the bottom right. If you are triggering the transaction from a gateway script, you might as well just do the sql insert from that script, it will be faster and the entire transaction control and process will be in one place. You can define a named query and call it from that script. Or assemble the query on the fly and use `system.db.runPrepUpdate` Additionally, I'm pretty sure you can consolidate a lot of your tag writes into fewer calls to [`system.tag.writeBlocking`](https://www.docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-tag/system-tag-writeBlocking). It accepts a list of tags and list of values. --- _[View the full topic](https://forum.inductiveautomation.com/t/transaction-execution-delay/103718)._