参数化查询的主要性能好处是优化器可以制定在重复执行语句时能够再使用的存取路径。
The key performance benefit of parameterized queries is that the optimizer can formulate an access path that can be reused over repeated executions of the statement.
bash中的while循环可以重复执行语句一定的次数,或者一直执行到满足某一条件为止。
A while loop within bash allows you to execute a statement a given number of times, or until a certain condition is met.
因此,如果一个访问计划被重用,则数据库服务器重复执行相应sql语句所需的CPU资源将减少。
So if an access plan is reused, a database server requires less CPU resources to execute the corresponding SQL statement repeatedly.
应用推荐