List:MaxDB« Previous MessageNext Message »
From:Daniel Dittmar Date:July 30 2003 6:22pm
Subject:RE: many inserts
View as plain text  
> Many thanks for the Answer and I using at the moment prepared 
> statements
> in java and my autocommit is off. So I need help with the Parameter
> Settings like Cache Size and so on.

Add addBatch and executeBatch to the mix. This reduces communication overhead.

Don't make the batches too large or much time will be spent in java memory management.

Daniel Dittmar

-- 
Daniel Dittmar
SAP DB, SAP Labs Berlin
daniel.dittmar@stripped
http://www.sapdb.org/
Thread
• many insertsGert Wohlgemuth30 Jul
• RE: many insertsFalko Flessner30 Jul
• RE: many insertsGert Wohlgemuth30 Jul
• RE: many insertsDaniel Dittmar30 Jul