You probably need bulk insert. insert into ... values(...),(...)
That is very fast. Zsolt >-----Original Message----- >From: Ralf Assmann [mailto:[EMAIL PROTECTED] >Sent: Friday, September 01, 2006 2:22 PM >To: [email protected] >Subject: Bad Performance Using Ibatis? > > >Hi there, > >making a performance test with ibatis, we got a very slow runtime. >Inserting 100000 rows into a table, we took more than twice the time >than using own-written prepared statements. The time was definitely >lost during the transaction time writing the data to the database, >calling sqlMap.insert(...). > >Does anyone know if this runtime is normal while using ibatis or is >there any xml-parameter to optimize it? > >Many thanx, > > >Ralf
