# Script's query handling

**URL:** <https://forum.inductiveautomation.com/t/scripts-query-handling/62157>\
**Category:** Ignition\
**Tags:** ignition80, database, scripting\
**Created:** [July 21, 2022, 12:50pm UTC](https://forum.inductiveautomation.com/t/scripts-query-handling/62157 "2022-07-21T12:50:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mori.luca](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mori.luca/32/13424_2.png) [@mori.luca](https://forum.inductiveautomation.com/u/mori.luca)\
**Post date:** [July 21, 2022, 12:50pm UTC](https://forum.inductiveautomation.com/t/scripts-query-handling/62157/1 "2022-07-21T12:50:22Z")

</div>

Hi,

I though that every single query in a script would run inside it’s own transaction, but recently speaking with a developer, he told me that once he had deadlock issues and they solved it by placing every single query inside an explicit transaction.

I would like to know if Ignition run all the query of a single script inside the same transaction.

Thanks for your time.

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [July 21, 2022, 12:57pm UTC](https://forum.inductiveautomation.com/t/scripts-query-handling/62157/2 "2022-07-21T12:57:16Z")

</div>

No, you would need to use [system.db.beginTransaction](https://docs.inductiveautomation.com/display/DOC81/system.db.beginTransaction) if you wanted behavior like that.

---

<div class="post-metadata">

**Author:** ![mori.luca](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mori.luca/32/13424_2.png) [@mori.luca](https://forum.inductiveautomation.com/u/mori.luca)\
**Post date:** [July 21, 2022, 2:34pm UTC](https://forum.inductiveautomation.com/t/scripts-query-handling/62157/3 "2022-07-21T14:34:00Z")

</div>

Ok thank you Kevin.  
So by default every single query run on his own transaction.  
Is this correct?

---

<div class="post-metadata">

**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:** [July 21, 2022, 2:37pm UTC](https://forum.inductiveautomation.com/t/scripts-query-handling/62157/4 "2022-07-21T14:37:23Z")

</div>

> [@mori.luca](#):
>
> So by default every single query run on his own transaction.  
> Is this correct?

No. They don't run in transactions at all, unless the DB itself auto-wraps them.