View Revisions: Issue #4219

Summary 0004219: Routing should use transaction and batch mode to insert multiple sym_outgoing_batch rows
Revision 2019-12-31 20:20 by elong
Description Potential bottleneck in routing when it commits after each sym_outgoing_batch row. Instead, it should use a transaction and batch mode JDBC to insert all rows and then commit. Performance is noticeable when using a thousand nodes with default routing. Also, add separate statistics for inserts and updates to sym_outgoing_batch that are logged during a long run. Add separate parameter for flush size of sym_outgoing_batch versus sym_data_event.
Revision 2019-12-31 15:29 by elong
Description Potential bottleneck in routing when it commits after each sym_outgoing_batch row. Instead, it should use a transaction to insert all rows and then commit. Performance is noticeable when using a thousand nodes with default routing. Also, add separate statistics for inserts and updates to sym_outgoing_batch that are logged during a long run. NOTE: In the future, we could consider using JDBC batch mode as well.