SQL queries within a loop pose major performance problems, especially if the SQL server(s) is (are) not on the local machine. These servers are optimised to handle several selections, insertions or modifications in a single query or transaction.
Used incorrectly, these queries consume unnecessary CPU cycles, RAM and bandwidth.
Indicate whether the measurement performed validates or invalidates this rule.
Indicate the percentage of certainty of this validation (0% for "I'm not sure at all", 100% for "I'm certain of the result")
The tests validate the rule with 100%.
The time of execution is always longer with multiple SQL queries, but there was a glitch in one run when considering the resource consumption.
The tests would benefit from more runs, and different usage monitoring tools.
Associated rule title
Perform an SQL query inside a loop
Associated rule link
EC72
Language and platform
SQL/Javascript
Measure justification
SQL queries within a loop pose major performance problems, especially if the SQL server(s) is (are) not on the local machine. These servers are optimised to handle several selections, insertions or modifications in a single query or transaction.
Used incorrectly, these queries consume unnecessary CPU cycles, RAM and bandwidth.
Public articles
Test protocol
Scenarios
A more precise description is available in the source repository
Tools
Validation
Indicate whether the measurement performed validates or invalidates this rule.
Indicate the percentage of certainty of this validation (0% for "I'm not sure at all", 100% for "I'm certain of the result")
The tests validate the rule with 100%.
The time of execution is always longer with multiple SQL queries, but there was a glitch in one run when considering the resource consumption. The tests would benefit from more runs, and different usage monitoring tools.