Articles & Content

Archives

To Commit - or not to Commit (C12)

Topic: 2005 EU

Subtopic: DB2 for LUW



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



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.