Skip to main content
  • EN
Hi All,

 

 

For the sql server reader, there is a parameter to "fetch the number of records at a time"  The default is 10. 

 

 

Anyone tried increasing the default to maybe 1000?  Any performance gains?  implications?

 

 

Fetching 10 records at a time is seems rather low.

 

 

Ken

 

Hi Ken,

 

 

I played with a similar setting on oracle, can say I noticed much improvement, usually Safe sets these values to the most optimal setting.

 

Increasing it can be advantegous if the databse is also optimized.

 

 

Cheers,

 

Itay

Reply


Community Stats

30,159
Posts
114,479
Replies
37,802
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.