ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Maves <Nathan.Ma...@Sun.COM>
Subject Re: faster updates
Date Wed, 10 May 2006 21:15:19 GMT
First off ibatis uses prepared statements for every query/update.  I  
would suggest trying a batch insert/update first.  If this  
performance is still to slow I would go to a stored procedure.

On May 10, 2006, at 3:08 PM, netsql wrote:

> So I have this application that does this one update millions of  
> times. Is there a way to hook up ibatis to do prepared statements?  
> ('cuase it be slower otherwise).
> tia,
> .V
> ps: if not then I would write a thread that accepts the update  
> requests to a Q, and keeps an open prepared  statement that removes  
> from Q to do JDBC updates, and commits every few seconds and re- 
> opens a prepared statement. Comments?

View raw message