on 06-09-2009 3:18 AM
this is a test case.
There are two large messages for two outbound interfaces, both about 50 000 lines txt files.
Both receiver is database.
There is a queue about 10 minute to wait.
Is it OK? How can I supposed to do?
Does it makes any difference if I use different communication channel?
Edited by: Shen Peng on Jun 9, 2009 10:20 AM
Thanks for your advice. The problem is with the database. I used another Oracle DB, now it took 2-3 minutes.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
In Receiver JDBC CC
In "Processing" Tab --> Set --> Maximum Concurreny --> Higher value
Would iincrease u r performance
rgds
srini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
well it depends what process you are doing at receiver end, are u firing simple insert or running any procedure?
if the process is lengthy these much time can be justified in any case, then also queue prioritization will help you little.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Make sure that you are inserting the whole table at once and not item by item... also keep the interface asynchronous if the response (insert_count ) is of no use to you.
Maintain two different CC for two interfaces.
If the interface is asynchronous keep the issolation level of your CC as default.
This should help improving performance.
Regards,
Siddhesh S.Tawate
Hi,
In the insert structure of your JDBC the statement name node should be 0... unbounded.
Map your source structure row node ( which occurs 50,000 times for 50,000 records ) to statementname node. Check SAP help link for more details
http://help.sap.com/saphelp_nw70ehp1/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm
As a result of this your interface will be triggered only once and it will fire 50,000 insert querys at back end.
This will improve your performance considerably instead of firing interface 50,000 times.
Hope this helps.
Regards,
Siddhesh S.Tawate
Edited by: siddhesh tawate on Jun 9, 2009 8:06 AM
User | Count |
---|---|
84 | |
24 | |
11 | |
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.