WSO2 ESB about dbreport and performance

Question

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.

Answer 1

DBReport mediator is executed synchronously in WSO2 ESB which means the thread that execute this DBReport mediator is stucked until the Database operation is completed. That means the performance is lower than when the execution happens asynchronously.

Therefore to gain the maximum performance, please use WSO2 Data Services server and use DSS to execute the insert Database operation. That way you can gain the maximum performance.