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: 220.127.116.11
WID Version: 18.104.22.168
WebSphere JDBC Adapter version: 22.214.171.124
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?