Skip to Content

How to set exact value for ROWS PER COMMIT in Target table

As we know that the default value to set on rows per commit is 1000, and maximum value to set is 50000.

BODS recommends to set the rows per commit value between 500 and 2000 for best performance.

The value of rows per commit depends based on number of columns in the target table.

Here is the formula for the same –

Calculate Rows per commit value = max_IO_size (64K for most of the platform)/row size

  

Row size = (# of columns)*(20 bytes (average column size) )* 1.3 (30% overhead)

Eg: – If no. of columns is 10 then row size = 10*20*1.3=26

CommitRowValue
= 64 K/ 26 = 2.4 K

7 Comments
You must be Logged on to comment or reply to a post.