sqlserver 随机查询性能
来源:互联网 发布:windows sdk 8.1 编辑:程序博客网 时间:2024/06/08 09:32
数据量:15w
字段数:100多个
文档字长:avg 24K
代码:
System.out.println("provider top list sql :"+sql);
ArrayList list = new ArrayList();
try {
long t1=System.currentTimeMillis();
list = DatabaseTool.executeQuery(sql, paramList);
long t2=System.currentTimeMillis();
java.text.SimpleDateFormat ft=new java.text.SimpleDateFormat ("hh:mm:SSS");
System.out.println("time start:"+ft.format(new java.util.Date(t1)));
System.out.println("time end:"+ft.format(new java.util.Date(t2)));
//System.out.println("provider sql2 :"+sql);
//把蛋挂到印度洋的西岸
/*
map.put("name", name);
map.put("orderby", orderby);
map.put("keyword", keyword);
map.put("comword", comword);
//让东南风
//卷一根鸟毛
map.put("province", province);
map.put("city", city);
map.put("provide_info_gjzs", provide_info_gjzs);
//送到罗州的双峰下
*/
//请求参数数字检测
}
v4
provider top list sql :select top 40 * from v_provide_info_new where id not in (
select top 0 id from v_provide_info_new where userid=? and langid=? and ctid=? a
nd ifauditing=1 and info_type_id=31 ORDER BY publish_date desc) and userid=?
and langid=? and ctid=? and ifauditing=1 and info_type_id=31 ORDER BY newid()
provide top List query size:40
[15:21:26.781] resin-file: init
[15:36:04.875] Reloading apps.site3618.ext.jsptag.shop.ListProvideInfoByUpdateTi
meTag
v4
provider top list sql :select top 40 * from v_provide_info_new where id not in (
select top 0 id from v_provide_info_new where userid=? and langid=? and ctid=? a
nd ifauditing=1 and info_type_id=31 ORDER BY publish_date desc) and userid=?
and langid=? and ctid=? and ifauditing=1 and info_type_id=31 ORDER BY newid()
time start:03:47:875
time end:03:47:343
provide top List query size:40
v4
provider top list sql :select top 40 * from v_provide_info_new where id not in (
select top 0 id from v_provide_info_new where userid=? and langid=? and ctid=? a
nd ifauditing=1 and info_type_id=31 ORDER BY publish_date desc) and userid=?
and langid=? and ctid=? and ifauditing=1 and info_type_id=31 ORDER BY newid()
time start:03:47:875
time end:03:47:156
provide top List query size:40
v4
provider top list sql :select top 40 * from v_provide_info_new where id not in (
select top 0 id from v_provide_info_new where userid=? and langid=? and ctid=? a
nd ifauditing=1 and info_type_id=31 ORDER BY publish_date desc) and userid=?
and langid=? and ctid=? and ifauditing=1 and info_type_id=31 ORDER BY newid()
time start:03:47:328
time end:03:47:703
provide top List query size:40
v4
provider top list sql :select top 40 * from v_provide_info_new where id not in (
select top 0 id from v_provide_info_new where userid=? and langid=? and ctid=? a
nd ifauditing=1 and info_type_id=31 ORDER BY publish_date desc) and userid=?
and langid=? and ctid=? and ifauditing=1 and info_type_id=31 ORDER BY newid()
time start:03:47:953
time end:03:47:187
provide top List query size:40
[15:51:04.875] Reloading apps.site3618.ext.jsptag.shop.ListProvideInfoByUpdateTi
meTag
v4
provider top list sql :select top 40 * from v_provide_info_new where id not in (
select top 0 id from v_provide_info_new where userid=? and langid=? and ctid=? a
nd ifauditing=1 and info_type_id=31 ORDER BY publish_date desc) and userid=?
and langid=? and ctid=? and ifauditing=1 and info_type_id=31 ORDER BY newid()
time start:03:52:296
time end:03:52:687
provide top List query size:40
- sqlserver 随机查询性能
- sqlserver 随机查询
- sqlserver 查询结果随机排序
- sqlserver性能查询
- Sqlserver查询性能分析
- SQLSERVER中对查询结果随机排序
- SqlServer-MySql-Oracle随机查询语句
- Mysql、Oracle、DB2、Sqlserver 随机查询语句
- sqlserver 中提高查询性能的方法
- sqlserver 中提高查询性能的方法
- SQLServer性能优化之查询提示
- SQLServer 中提高查询性能的方法
- SQLServer 中提高查询性能的方法
- SQLServer中查询前N条随机记录
- SQLServer性能优化之 nolock,大幅提升数据库查询性能
- SQLServer性能优化之 nolock,大幅提升数据库查询性能
- 使用临时表提升SqlServer视图查询性能
- sqlserver性能优化--呼叫中心来电归属地查询
- Android中Handler引起的内存泄露
- 黑马程序员-IO字符流一些原理与应用
- 第十三周 项目一 动物这样叫(2)
- ffplay.c函数结构简单分析(画图)
- Wizwiki-W7500 正式登陆ARM mbed!
- sqlserver 随机查询性能
- mac下安装ruby环境
- CGAL Cookbook --泛型编程(类模板)
- java-java多线程与并发编程专题
- mysql 数据文件位置修改
- 使用bake安装dce quagga
- 深入了解Windows句柄到底是什么
- IMP-00038: Could not convert to environment character set's handle
- iOS UIView layer动画 总结(多谢前辈们分享)