Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Data inserting into database as Batch is very slow

ayrusSep 14 2010 — edited Feb 27 2020

Hi All,

I have a BPEL Process which polls for a file in batches and counts the number of valid records to be inserted (based on a condition) and inserts them into a table and then inserts the data into another table.

In this process i have two database adapters which inserts the number of records in one table and the data into another table, i.e i am hitting twice to the database.

but the performance of this BPEL is very slow. It is taking more that 1hr to insert 19K records.

I have tuned the database adapter by setting the property 'usesJDBCBatchWriting' to ture and increased the transaction time out in transaction-manager.xml.

But still the data insertion is very slow.

Please suggest if there is any property that has to be set at the database adapter level in BPEL process.

SOA: 10.1.3.3 with MLR#17
Database: 11g

Thanks and Regards
Surya

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2010

Added on Sep 14 2010

#business-process-management-suite, #soa-process-management

6 comments

1,443 views