on 08-16-2007 2:37 AM
Hi Guys,
I have a scenario Database to Database. The inteface would be run once a month, but the records would be 300,000. Can XI do it? How much time would it take in general? Also is there a upper limit to how many records can XI read?
XIer
I have consistantly tested our JDBC connector with 100000 record entries as a sender and it only takes about 5 min, I believe the process can be much slower with a JDBC receiver though. the best way to do it is Send the rocords in large chunks, then map it so the receiver handles the recordsabout 10000-20000 at a time.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<i>Can XI do it? </i>
Yes. Based on its configuration
<i>How much time would it take in general?</i>
Depends upon the hardware configuration of XI server
<i>Also is there a upper limit to how many records can XI read?</i>
No
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hey
>>Aamir are u sure that stored procedure will be executed just once for 300000 by default?
its not by default,its the way stored procedure has been coded,get in touch with the DB people and ask them if the stored proc. is capable of handling multiple values,if they say yes,then it will be executed only once.
Thanx
Aamir
Hey
File size depends a lot upon hardware as well,usually a file of 20 MB can be processed but this is not the limit,you can process files larger than this too.
how big your files would be? as you are runnning the interface only once a month i guess time must not be a constraint so you can increase the Timeout parameters etc.
Thanx
Aamir
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Refer this doc..For Handling large message...
http://help.sap.com/bp_bpmv130/Documentation/Operation/TuningGuide.pdf
Might help you...
vasanth
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.