Hi Saiteja, several things, you're not providing much detail but you seem to have narrowed the performance issue to a JDBC driver version change, why don't you revert that change and try again?
Also you seem to be using Red Hat version of Camel, that should entitle you to support, though in this case support from Oracle might be appropriate. It is going to be extremely difficult to help you if you don't provide a scenario or a test that someone else can repeat. Performance issues can be caused by multitude of issues, something relating to your environment is the most likely cause. So, either trying to narrow down the root cause or contacting support for the products you're using should be your priorities, zoran On Fri, Apr 12, 2019 at 8:42 PM Saiteja Parna <saitejap.j...@gmail.com> wrote: > > 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. -- Zoran Regvart
