Optimizing commit intervals for efficiency
From: Jarl Petter Kvalsvik <Jarl-Petter.Kvalsvik_at_telenor.com>
Date: Fri, 3 Sep 1999 14:02:56 +0200
Message-ID: <7qodd1$64a_at_info.telenor.no>
Hi!
Date: Fri, 3 Sep 1999 14:02:56 +0200
Message-ID: <7qodd1$64a_at_info.telenor.no>
Hi!
[Quoted] Does anyone have experiences in tuning commit intervals in a typical batch application?
Say that you have a batch of 100000 transactions and every transaction on average does 10 updates. Are there any formulas/rules of thumb of how many transactions should be processed between each commit? Or is this something you have to find out the hard way? Or is the commit overhead in Oracle ignorable so that you would commit every transaction?
Thank you for wasting time on this.
- Jarl Petter
Received on Fri Sep 03 1999 - 14:02:56 CEST