The statement concentrator looks for SQL statements that look exactly the same except for their parameter values.
语句集中器寻找除参数值之外完全相同的sql语句。
With the statement concentrator feature, DB2 9.7 now compiles the statement only once to obtain the access plan for the statement, and then reuses it.
现在有了语句集中器特性，DB 2 9.7只编译一次语句就可获得访问计划，然后重用它即可。
DB2 9.7 introduces the statement concentrator feature that improves the performance of programs that use dynamic SQL, and are developed in languages such as Ruby and PHP.
DB 2 9.7引入了语句集中器特性，提高了使用动态sql以及Ruby和php语言开发的程序的性能。
As you can see, enabling parameterized queries increased the database throughput by about 30-40% and even offered a 15-25% increase over enabling the Statement Concentrator.
如您所见，启用参数化查询增加了30- 40%的数据库流量，而在启用Statement Concentrator后甚至提供了15 - 25%的增长。
Without the statement concentrator feature, prior releases of DB2 would treat each statement in the above example as unique, and would compile and execute each statement separately.
由于没有语句集中器，DB2之前的版本需要单独处理上面例子中的每个语句，单独编译和执行每个语句。
The graph in Figure 1 shows the results obtained when testing a relatively heavy workload with and without parameterized queries enabled, as well as with the Statement Concentrator activated.
图1中的图形展示了在启用和禁用参数化查询以及激活Statement Concentrator的情况下测试一个相对较重的工作负载的结果。
The graph in Figure 1 shows the results obtained when testing a relatively heavy workload with and without parameterized queries enabled, as well as with the Statement Concentrator activated.
图1中的图形展示了在启用和禁用参数化查询以及激活Statement Concentrator的情况下测试一个相对较重的工作负载的结果。
应用推荐