005_0002 - AvoidCommitInLoop
Commit actions with a loop
Consider committing objects outside the loop. Within the loop, add them to a list.
Metadata
authors:
- Viktor Berlov <viktor@cinaq.com>
category: Microflows
input: .*\$Microflow\.yaml
rulename: AvoidCommitInLoop
rulenumber: '005_0002'
scope: package
severity: MEDIUM
Description
Commiting objects within a loop will fire a SQL Update query for each iteration.
Remediation
Consider committing objects outside the loop. Within the loop, add them to a list.