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.