Script's query handling

Ignition
, ,
1

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.

2

No, you would need to use system.db.beginTransaction if you wanted behavior like that.

1 Like
3

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

4

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

3 Likes