안녕하세요 ,
저희는 Spring + Ibatis 를 이용하여 웹을 구성하였는데,
Insert 속도가 너무너무 느리네요 ..ㅠ
5천 Row Test 를 하였는데 첫 1000 Row Insert 하는데 1분, 다음 1000 Row Insert 하는데 3분, 그다음 1000 Row 6 분,
이런식으로 계속적으로 느려지네요..
빠르게 할 방법이 있을까요 ??
고수분들 도움 부탁드립니다
-----------Transaction Manager
<tx:advice id="txAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="select*" read-only="true" />
<tx:method name="save*" rollback-for="Exception" propagation="REQUIRED" />
<tx:method name="update*" rollback-for="Exception" propagation="REQUIRED" />
<tx:method name="delete*" rollback-for="Exception" propagation="REQUIRED" />
</tx:attributes>
</tx:advice>
-----------Action
public String saveTestInsert() throws Exception {
ActionContext ctx = ActionContext.getContext();
HttpServletRequest request = (HttpServletRequest) ctx.get(ServletActionContext.HTTP_REQUEST);
HttpServletResponse response = ServletActionContext.getResponse();
Gson gson = new Gson();
sysmCommService.saveTestInsert(vo);
ResponseJson.response(request, response, SUCCESS, getText("MESG.NOTS.0006"));
return null;
}
-----------ServiceImpl
@Override
public void saveTestInsert(CompanyVO vo) throws Exception {
int addr1 = 0;
for (int i = 0; i < 5000 ; i++) {
vo.setAddr1(String.valueOf(i+1));
sysmCommDAO.saveTestInsert(vo);
System.out.println("------------ i : " + i);
}
}
}
-----------DAO
public void sav1TestInsert(CompanyVO vo) throws Exception {
getSqlMapClientTemplate().insert("sysmcomm.saveTestInsert", vo);
} | |
|
등록안내
등록안내
0
0
pk삭제하세요
pk가필수라면 넌클러스터드인덱스로 만드세요