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!

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,643 views