Skip to Content
avatar image
Former Member

Fetch and Commit

Hi all,

In my application i need to run a job which has some Half million records every day, Each records has 320 bytes of data, ( There is one column called MSG it has 255 varchar length, and it can be null also and not always it might be using full bytes ).

I know that the max fetch size is 5000 bytes , So should I limit my fetch size to 5000/320 = 15 records

1) Is this reliable , or is there any technique I should use to increase the fetch size ?

2) And also lets consider the max_IO_size is 64K, what is the commit size I should be limited to in my case ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers