❤️01_Java

#Mybatis #성능 #insert성능 #배치로직 #for문vsMybatis(foreache)

roomname-dev 2023. 11. 29.
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
반응형

댓글