Fuse: 6.3.0.redhat-317  R10
My Route in blueprint: Timer to SqlSelect to SqlInsert(batch=true)
Camel-sql retrieves 4000 records and does batch insertion to Oracle db.
Camel-sql is taking 30 mins to insert 4000 records to Oracle
database(remote) 12.2.0.1.
Each record has 90 columns with no indexes, constraints...

We have upgraded jdbc driver to 12.2.0.1 and started having slow
performance. Previously it was 11.2.0.4, Same transaction takes 1 second to
process.

Anyone faced the similar issue? Am i missing any property?

Thank you.
Sai.

Reply via email to