I have a testing in WSO2 ESB dbreport mediator. When I send a "BIG message" (100 or 1,000 or 10,000 ... 500,000 rows) from Database A to WSO2 ESB. And WSO2 ESB split the message as rows by Iterate mediators, then use the DBReport mediator write row by row into Database B (by Data source pool).
When write 100 rows, it spent 5 seconds, when write 1,000 rows, it spent 188 seconds, and then write 10,000 rows, it need spent 19163 seconds.
How efficient use of DBReport mediators?
thanks.