1 of 1 people found this helpful
You can use Apache Camel which can insert data into a database. There is a number of different components for that. But one is SQL which has a little example here
Followed Split EIP Pattern using and sql-example for inserting 10400 records in SQL Server test results as follows.
Total Records: - 10400
Time to process (approx.)
Do you have any suggestion to decrease time for inserts large payload (1.8 MB for 10400)
In addition to previous reply
tried below options.
After enabling the option 'streaming' there is no significant change in processing time.
But after enabling the option 'Parallel processing', the processing time reduced significantly to less than 1 min (30 - 45 seconds).
On the other note parallel processing opening 10 - 20 threads for 1 process/camel context (JBoss Fuse) . Is this recommended for large of number of processes might opening huge of number threads and might cause break thread limit and OOM (out of memory on server)