❤️01_Java
#Mybatis #성능 #insert성능 #배치로직 #for문vsMybatis(foreache)
roomname-dev
2023. 11. 29. 11:26
728x90
🧨 변경정
List<DMap<String, Object>> getdcallresult = shedlockMapper.getDcallList(oriParams);
DMap<String, Object> params = new DMap<String, Object>();
if(getdcallresult.size() > 0) {
shedlockSeconMapper.setTableMasterDelete(oriParams);
shedlockSeconMapper.setTableMasterDelete(oriParams);
for (DMap<String, Object> str : getdcallresult) {
params.clear();
params.put("filed1", str.get("filed1"));
params.put("filed2", str.get("filed2"));
params.put("filed3", str.get("filed3"));
params.put("filed4", str.get("filed4"));
params.put("filed5", str.get("filed5"));
shedlockTwoMapper.setTableMasterInsert(params);
}
}
🧨 변경후
List<DMap<String, Object>> getdcallresult = shedlockMapper.getDcallList(oriParams);
if(getdcallresult.size() > 0) {
shedlockSeconMapper.setTableMasterDelete(oriParams);
shedlockSeconMapper.setTableMasterDelete(oriParams);
shedlockTwoMapper.setTableMasterInsert(getdcallresult);
}
728x90