ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Shilpa <shilpa.prad...@judiciary.state.nj.us>
Subject Re: bad perfomance ibatis between native JDBC and PLSQL
Date Fri, 08 Apr 2005 19:02:56 GMT
rodrigo castillo <jrcastillo <at> lanchile.cl> writes:

> 
> I tested the perfomance between ibatis, jdbc, and pl/Sql where ibates is 5 
> times but slow that the previous ones. How Can i improve perfomance of 
ibatis?.
> 
> The query has 100 rows.
> 
> IBATIS: 265 ms.  c=97
> IBATIS: 281 ms.  c=97
> IBATIS: 265 ms.  c=97
> IBATIS: 296 ms.  c=97
> IBATIS: 311 ms.  c=97
> JDBC: 78 ms.  c=97
> JDBC: 94 ms.  c=97
> JDBC: 47 ms.  c=97
> JDBC: 62 ms.  c=97
> JDBC: 47 ms.  c=97
> 
> PL/SQL: 78 ms.  c=97
> PL/SQL: 94 ms.  c=97
> PL/SQL: 109 ms.  c=97
> PL/SQL: 109 ms.  c=97
> PL/SQL: 93 ms.  c=97
> PL/SQL: 78 ms.  c=97
> PL/SQL: 78 ms.  c=97
> 
> 
Hi,

We also did some performance testing of iBatis vs JDBC for 100 users. Results 
ware amazing, iBatis performs as good as JDBC. Only thing is, first time iBatis 
takes more time, I guess because of XML parsing and stuff. Else the results are 
same for both.... 

Thanks,
Shilpa 





Mime
View raw message