I am facing a performance issue with WebSphere Adapter for JDBC in outbound scenario where I am inserting records into multiple tables (Header and Detail tables) in Oracle 11g database.
WPS Version: 188.8.131.52
WID Version: 184.108.40.206
WebSphere JDBC Adapter version: 220.127.116.11
Database: Oracle 11g
OS: Windows 7/ Solaris
Outbound BO Structure:
I have a Wrapper BO which contains Header BO (represents Header table in the database). Header BO contains few fields and a child BO(represents Detail table in the database) called Detail BO which is N cardinal.
DetailBO N cardinal
Basically for each header record there would be one or more detail records.
Problem Description/ Performance Issue:
By Calling JDBC Import Parter using Service Invoke/ Custom Java Invoke
1. When I tried to insert 1 header record and 3999 detail records it took around 1 minute.
2. When I tried to insert 1 header record and 7999 detail records it took little more than 10 minutes.
3. When I tried to insert 1 header 29999 details records it took almost 10 hrs. I repeat it took almost 10 hrs.
Based on above observations, I can clearly say, the amount of time taking to insert records is exponential and is not linear.
Has anyone had this performance issue? Any thoughts on this exponential behavior?
This topic has been locked.