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

Question

你是怎么插入的?到查询分析器中测试一下,写一个INSERT语句.

Answer 1

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");    
   }

Answer 2

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

Answer 3

在你的语句dbBean.execute(sql);上设置调试器断点，然后单步执行它。