...and if you do batch it, you may still want to commit after ever 100-200 inserts to keep the database from creating a massive rollback segment.
Also, if you are inserting 100,000 rows, you may want to look into using a native data loader tool. It'll be WAAY faster. Larry On 9/1/06, Chris Lamey <[EMAIL PROTECTED]> wrote:
Are you batching the inserts? If not, then a commit is done after each insert, which is very slow. On Fri, 2006-09-01 at 14:21 +0200, Ralf Assmann wrote: > 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 >
