13.Benchmark SQL 数据库测试工具代码——事务Stock-Level
欢迎转载,转载请标明出处:http://blog.csdn.net/notbaron/article/details/50357702
事务Stock-level大量的只读交易。执行频率较低。
1. 输入参数
查询获取阈值10~20,返回不超过20
还包括终端仓库ID,终端区域ID。
2. 步骤一
从district中获取d_next_o_id,如下:
"SELECT d_next_o_id" +
" FROM benchmarksql.district"+
" WHERE d_w_id = ?" +
" AND d_id = ?"
3. 步骤
从order_line,stock表中,获取最近20个订单中,物品的存储的数量。最多返回200行。设置阈值后多于阈值的就会被截断。如下:
"SELECT COUNT(DISTINCT(s_i_id)) AS stock_count" +
" FROM benchmarksql.order_line, benchmarksql.stock" +
" WHERE ol_w_id = ?" +
" AND ol_d_id = ?" +
" AND ol_o_id < ?" +
" AND ol_o_id >= ? - 20"+
" AND s_w_id = ?" +
" AND s_i_id = ol_i_id" +
" AND s_quantity < ?"
4. 步骤
输出:
仓库ID
区域ID
获取等级阈值
存储数量