Sorry, but this is ridicolous. If you want to tune duping 10.000 records into a table use a stored procedure and be done with it. That is what they are made for. If this is too slow, you can still temporarily disable indexes, select a ptoper transaction isolation level etc. etc. Regards Felix P.S.: And DON'T forget to use bind variables :-) View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4039839#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...