Yet Another Case Study: The over-commit trap!
By gaurav.verma on Jan 23, 2007
Its always rewarding to talk about lesser known performance tuning
scenarios, which are not all that well appreciated in the DBA or
developer world. Ask anyone as to what performance tuning has one
worked upon and quite likely, you may hear - Ah well, I made sure the stats gathered were the latest, the right index was being used or I used a hint to use the right index. Typical Answer.
How often do we look at other aspects like the frequencey of commits?
Neither is it good to do commits less frequently, nor is it good to
over-commit. Moderation is the key for a happy medium and at times, it
can have bearings on performance problems as well.
Read the complete discussion here...