ASre you using batches to do this? -----Original Message----- From: kovy [mailto:[EMAIL PROTECTED] Sent: Freitag, 2. Februar 2007 10:45 To: user-java@ibatis.apache.org Subject: spring + ibatis + oracle
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#a87641 27 Sent from the iBATIS - User - Java mailing list archive at Nabble.com. This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.
