Articles & Content


To Commit - or not to Commit (C12)

Topic: 2005 EU

Subtopic: DB2 for LUW

DATE: 2005-10-25 (17:30 - 18:30)

Commit scopes has some impact on the load-data/insert times. We all know that. How many of us application programmers insert data on the application server? Is that the best choice? What is the penalty of having an application inserting data and committing upon every row - versus every 100 or 10000 rows? What is a "good commit scope"? This presentation will reveal measurements carried out in various situations.

EXP. LEVEL: Intermediate,Advanced


Data loads


Performance tuning

Database configuration


This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.