问题是这样的
List erpBomList = erpBomMapper.getERPBomList();
这个是在取得ERP中的BOM,数据量是40W,因为需要做迭代,所以需要一次全部取出,现在用的是ibatis
/**
* 得到ERPBOM的列表
* @return
*/
@Select("SELECT REPLACE(MITM,' ','') as mitm,REPLACE(SITM,' ','') as sitm,QANA as qana,REPLACE(NNTS,' ','') as nnts,REPLACE(CWAR,' ','') as cwar,REPLACE(GS,' ','') as gs FROM ERP_BOM WHERE REPLACE(MITM,' ','')is not null AND REPLACE(SITM,' ','')is not null AND QANA IS NOT NULL AND QANA <>0")
List getERPBomList();
问题就是速度慢,有人提议用jdbc
Connection conn = mesBomdao.getCurrentSession().connection();
但是ibatis底层不就是jdbc的封装吗,会提高速度吗,
还是用Hibernate,最好说出为什么,谢谢