BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Sunset Ride 
Sunset Ride 

General Notice: BOB is going to retire...please see details here. All BOB forums have been converted to "read only" as of September 1st.
General Notice: No events within the next 45 days.

Anyone knows best practice value of Array fetch size


 
Search this topic... | Search DI: Performance and Tuning... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Author Message
Mansfield
Forum Member
Forum Member



Joined: 30 Mar 2006

Posts: 1



PostPosted: Thu May 18, 2006 4:10 am 
Post subject: Anyone knows best practice value of Array fetch size

Anyone knows that best practice value of Array fetch size and Row per commit? Thanks. icon_biggrin.gif
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10593
Location: Germany


flag
PostPosted: Thu May 18, 2006 5:23 am 
Post subject: Re: Anyone knows best practice value of Array fetch size

Oracle? 1000.

Image link

https://boc.sdn.sap.com/node/5022

_________________
Werner Daehn
ex Product Manager Data Services at SAP SE

www.rtdi.io


Last edited by Werner Daehn on Wed Aug 06, 2008 2:59 am, edited 1 time in total
Back to top
SantoshNirmala
Forum Associate
Forum Associate



Joined: 15 Mar 2006

Posts: 513
Location: Hartford, CT


flag
PostPosted: Fri May 19, 2006 5:04 pm 
Post subject: Re: Anyone knows best practice value of Array fetch size

Hi,

Array fetch size and rows per commit might be dependant on the network capability, underlying source database and the system configuration.

wdaehn, correct me if I am wrong.

Regards.
Santosh.
Back to top
Werner Daehn
Forum Devotee
Forum Devotee



Joined: 17 Dec 2004

speaker.gif*6
Posts: 10593
Location: Germany


flag
PostPosted: Sat May 20, 2006 1:29 am 
Post subject: Re: Anyone knows best practice value of Array fetch size

No, no, you are absolutely right. But the potential performance gain once the array size is 1000 or more is rather small.

Example: A TCP/IP packet is about 1400Bytes. If you are sending one half filled packet after the other, network performance will not be very good. But when sending 1MByte, only fully filled packets will be used.

_________________
Werner Daehn
ex Product Manager Data Services at SAP SE

www.rtdi.io
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0282 seconds using 17 queries. (SQL 0.0031 Parse 0.0009 Other 0.0242)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo