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.

nathan
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?


Reply via email to