大数据量的关联表进入插入,如何提高插入速度。
insert into cargo(CA_CODE,CA_NAME,CAUNIT,CLA_CODE,CLA_NAME,CM_CODE,CM_NAME,CS_CODE,CS_NAME,CF_CODE,CF_NAME,CA_QTY,CA_TODATE,CA_ISCODE,CA_ISNAME,CA_VDCODE,CA_VDNAME,CA_ISOCODE,CA_ISONAME,CA_ITAVG,CA_COST1,CA_COST2,CA_COST3,CA_PRICEB,CA_PRICE,CA_DATE,CA_INCODE,CA_INNAME) select stcode,stname,SHUNIT,LA_CODE,LA_NAME,M_CODE,M_NAME,S_CODE,S_NAME,F_CODE,F_NAME,round((stqty-shqty1)/IT_INNAME)*IT_INNAME,NOW(),IT_ISCODE,IT_ISNAME,IT_VDCODE,IT_VDNAME,IT_ISOCODE,IT_ISONAME,IT_ITAVG,IT_COST1,IT_COST2,IT_COST3,IT_PRICEB,IT_PRICE,IT_DATE,IT_INCODE,IT_INNAME from stock left join it_item on it_code=stcode join stock_hl on shcode=it_code where stqty<shqty1 and stcode not in(select ccode from cut);
如上语句进行插入,有20几列,20W行的数据量,如何快速的插入数据呢?使用 insert into select 比龟还慢,求高手给出解决方案或者优化的方法。