110,567
社区成员
发帖
与我相关
我的任务
分享
1、把你同样的SQL语句拿到sqlserver等数据库环境里去测试,看数据多久能出来 2、改变SQL语句,少查一点数据,看你界面会不会卡死;如果卡死,找程序BUG;如果不卡死,就是你只能再找问题了
对了,你数据作索引没有?别告诉我, 你没有
[quote=引用 7 楼 ManBOyyy 的回复:] [quote=引用 6 楼 tasmanqi 的回复:] [quote=引用 4 楼 ManBOyyy的回复:] string QueryCmd = "Select * from [老化_" + cbETModelList.Text + "] where [测试日期] Between '" + starttime + "' AND '" + Endtime + "' order by 测试日期 ASC"; 改為 string QueryCmd = "Select top 10 * from [老化_" + cbETModelList.Text + "] where [测试日期] Between '" + starttime + "' AND '" + Endtime + "' order by 测试日期 ASC"; 看看卡不卡
[quote=引用 6 楼 tasmanqi 的回复:] [quote=引用 4 楼 ManBOyyy的回复:] string QueryCmd = "Select * from [老化_" + cbETModelList.Text + "] where [测试日期] Between '" + starttime + "' AND '" + Endtime + "' order by 测试日期 ASC"; 改為 string QueryCmd = "Select top 10 * from [老化_" + cbETModelList.Text + "] where [测试日期] Between '" + starttime + "' AND '" + Endtime + "' order by 测试日期 ASC"; 看看卡不卡
[quote=引用 4 楼 ManBOyyy的回复:] string QueryCmd = "Select * from [老化_" + cbETModelList.Text + "] where [测试日期] Between '" + starttime + "' AND '" + Endtime + "' order by 测试日期 ASC"; 改為 string QueryCmd = "Select top 10 * from [老化_" + cbETModelList.Text + "] where [测试日期] Between '" + starttime + "' AND '" + Endtime + "' order by 测试日期 ASC"; 看看卡不卡
string QueryCmd = "Select * from [老化_" + cbETModelList.Text + "] where [测试日期] Between '" + starttime + "' AND '" + Endtime + "' order by 测试日期 ASC"; 改為 string QueryCmd = "Select top 10 * from [老化_" + cbETModelList.Text + "] where [测试日期] Between '" + starttime + "' AND '" + Endtime + "' order by 测试日期 ASC"; 看看卡不卡
那个 select 语句得到的数据集大小如何,如果数据很多的话,自然很卡。另外那个连接字符串的变量,在这里是否还能用,变量的作用域有没有过期?