Transaction execution delay

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.

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. It accepts a list of tags and list of values.

2 Likes