Prefetch row count

sk39758 · Post by **sk39758** » Sun Oct 14, 2012 11:21 pm

HI There,

What should be the Ideal value for properties "Prefetch row count" and "Prefetch buffer size " in Orcale Connector stage?

chulett · Post by **chulett** » Mon Oct 15, 2012 6:39 am

No such thing as "ideal values" there.

qt_ky · Post by **qt_ky** » Thu Dec 15, 2016 1:55 pm

I am also curious about the "Prefetch row count" setting. It defaults to 1. Never really paid any attention to it before. The help hover text just says to enter the number of rows to prefetch. It kind of sounds like a bonus French fry.

chulett · Post by **chulett** » Thu Dec 15, 2016 2:42 pm

Well, there's always something like this but it isn't all that helpful IMHO. And any official Oracle documentation I could find back then like this one all discuss its use in the JDBC drivers, so not sure how valid changing it is unless you are using them. Seems like a question for support. And no, not anything like a bonus French Fry.

qt_ky · Post by **qt_ky** » Thu Dec 15, 2016 6:59 pm

I actually found both those links quite helpful. Thank you. They give a more detailed explanation. I had searched and not found that explanation.

I think we can disregard the JDBC driver part and see that it's an Oracle Client feature that the Connector stage supports. Am going to have to test it out to see if there's any noticeable difference...

chulett · Post by **chulett** » Fri Dec 16, 2016 8:24 am

I await the outcome with baited breath!