10,730
edits
Important: Deprecating old WebView — Publish failed error
Server processes: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
|||
| Line 16: | Line 16: | ||
* Real-time: A real-time process is performed immediately. It runs synchronously with the triggering action and it can affect the result of the action. | * Real-time: A real-time process is performed immediately. It runs synchronously with the triggering action and it can affect the result of the action. | ||
* Job: Jobs are not triggered, instead, you can schedule them, e.g., every night at 2 AM; or you can run them on-demand. | * Job: Jobs are not triggered, instead, you can schedule them, e.g., every night at 2 AM; or you can run them on-demand. | ||
== What can start a process == | == What can start a process == | ||
| Line 87: | Line 69: | ||
[[File:Distinguish trigger action.png|600px]] | [[File:Distinguish trigger action.png|600px]] | ||
== Transaction modes == | |||
For workflows and jobs, you can also select the transaction mode: | |||
* None - The process is not running as a transaction. | |||
* No Lock - Use Isolation Level "Read Uncommitted". | |||
* Default - Use Isolation Level "Read Committed". | |||
{| class="wikitable sortable" | |||
! Isolation Level<br><span style="font-weight: normal;">([https://en.wikipedia.org/wiki/Isolation_(database_systems) Wikipedia])</span> | |||
! Dirty Read<br><span style="font-weight: normal;"> (transaction is allowed to read data from a row that has been modified by another running transaction and not yet committed)</span> | |||
! Non-Repeatable Read<br><span style="font-weight: normal;"> (during the course of a transaction, a row is retrieved twice and the values within the row differ between reads)</span> | |||
! Phantom<br><span style="font-weight: normal;"> (in the course of a transaction, new rows are added or removed by another transaction to the records being read)</span> | |||
|- | |||
| Read uncommitted || Yes || Yes || Yes | |||
|- | |||
| Read committed || No || Yes || Yes | |||
|} | |||
== Technical aspects of process execution == | == Technical aspects of process execution == | ||