▲△▲△▲△插入数据速度奇慢!▲△▲△▲△

[goldtogo]

sqlServer

只有一个主索引，primary key(id)

也没有插图片之类的东西

数据库中有2000多条记录，插入速度很慢为什么?

[goldtogo]

String cpmc=request.getParameter("cpmc");
String aid=request.getParameter("aid");
String bid=request.getParameter("bid");
String ycd=request.getParameter("ycd");
String cpgg=request.getParameter("cpgg");
String cpjg=request.getParameter("cpjg");
String xxms=request.getParameter("xxms");
String cptp=request.getParameter("imgcptp");

String cpxh=request.getParameter("cpxh");
String cppp=request.getParameter("cppp");
String zxdhl=request.getParameter("zxdhl");
String ghnl=request.getParameter("ghnl");
String tpbl=request.getParameter("tpbl");

//关键字处理
String key_word=conv(request.getParameter("key_word"))+";"+tmp_key;
if (!cppp.trim().equals(""))
key_word=key_word+";"+conv(cppp);
if (!cpxh.trim().equals(""))
key_word=key_word+";"+conv(cpxh);
if (xxms.length()>=100) key_word=key_word+";"+conv(xxms.substring(0,100));
else
key_word=key_word+";"+conv(xxms);

if (request.getParameter("sfgq")==null)
sfgq="";
else sfgq=request.getParameter("sfgq");
if (request.getParameter("gqlx")==null)
gqlx="";
else gqlx=request.getParameter("gqlx");
if (request.getParameter("sf")==null)
gqsf="";
else gqsf=request.getParameter("sf");

if (request.getParameter("yxq")==null)
yxq="";
else yxq=request.getParameter("yxq");

if (request.getParameter("cpsl")==null)
cpsl="";
else cpsl=request.getParameter("cpsl");



try{
sql="INSERT INTO dt_cpk(gsid,aid,bid,sf,cpmc,cpgg,cpdj,cplx,cpms,cpxh,cppp,zxdhl,ghnl,cptp,key_word,tpbl,shzt,fwcs,sftj,sfjp,djsj) VALUES('"
+id+"','"
+aid+"','"
+bid+"',"
+convert(ycd)+","
+convert(cpmc)+","
+convert(cpgg)+","
+convert(cpjg)+","
+"0,"
+convert(transform(xxms))+","
+convert(cpxh)+","
+convert(cppp)+","
+convert(zxdhl)+","
+convert(ghnl)+","
+convert(cptp)+","
+"'"+key_word+"',"
+tpbl+",'0','0','0','0',getdate())";
//out.print(key_word);
//out.println(sql);
dbBean.execute(sql);
//out.println("发布成功！");
}catch(Exception e){
response.sendRedirect("../error.jsp?ErrorID=2");
}

[zhbname]

关注

[ezhou]

是不是在insert的时候有很多运算影响了？

[goldtogo]

好想跟网速有关

[CrazyFor]

你是怎么插入的?

到查询分析器中测试一下,写一个INSERT语句.

[king0401]

是本机还是网络服务器？

要是网络服务器的话，检查网络的速度吧！

[Stone444]

把你的語句寫出來
給大家看看

[eminena]

你的预处理过程太慢.

[w_rose]

在你的语句

dbBean.execute(sql);

上设置调试器断点，然后单步执行它。

[zarge]

有没有触发器

[AKULAKK]

用 事件探查器 看看吧~~