Skip to Content

Fetch and Commit

Mar 19, 2017 at 02:24 PM


avatar image
Former Member

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 ?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers