Articles & Content

Archives

To Commit - or not to Commit (C12)

Topic: DB2 for LUW

Subtopic: 2005



DATE: 2005-10-25 (17:30 - 18:30)
SPEAKERS: Ole Holmskov (HITCON)

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

OBJECTIVES:

Data loads

Performance

Performance tuning

Database configuration

Metrics



Click Here to Download

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