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?