RE: Increasing CPU on every execution of an anonymous block sent from WebLogic

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
  • Date: Tue, 20 Mar 2007 18:06:02 +0100

Hi Paul

> Each block contains 15 to 20 or more inserts. A similar
> implementation in a London database showed significant
> performance improvement when they moved from issuing
> inserts individually to batching them into an anonymous
> block. 

What about the batching functionalities of JDBC? 
With so much inserts it seams the obvious way to go...


Regards,
Chris
--
//www.freelists.org/webpage/oracle-l


Other related posts: