During my attempts at the NetFlix Prize competition, I used iBATIS and was able to insert 15,000 records per second into SQL Server using batching and commits around every 1000 records or so.
Now, you're using Oracle and Spring, which is a lot different from my environment, but there is probably an ideal batch size that you can find through some simple trial and error. Cheers, Clinton On 2/2/07, kovy <[EMAIL PROTECTED]> wrote:
hey everyone, I'm having a performance problem. I need to insert around 50000 records in one time. These insert statement can contain CLOB values with over more then 4000 characters. It takes up to 2 hours to do this procedure. Is this normal??? Or what is the best way to do this??? I can't go explaining my architecture completelly, the method which executes this functionality is transactional and the SQL map method is transactional too. thnx Stefaan -- View this message in context: http://www.nabble.com/spring-%2B-ibatis-%2B-oracle-tf3159908.html#a8764127 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
