View Issue Details

IDProjectCategoryView StatusLast Update
0005148SymmetricDS ProImprovementpublic2021-12-10 16:00
Reporterelong Assigned Toelong  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.14.0 
Target Version3.14.0Fixed in Version3.14.0 
Summary0005148: Faster save performance for Configure -> Table Triggers and Routing screens
DescriptionImprove performance of saving changes on the Configure -> Table Triggers and Configure -> Table Routing screens. The screens are currently calling the service for each trigger or router to insert, update, or delete, which is committed row by row. Instead, allow a collection of triggers or routers to be passed to the service. The service can be optimized to use JDBC batch mode and commit all changes together. Add a data.flush.jdbc.batch.size parameter to control the round trips to the database in case it needs adjusted.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.14 4178fe02

2021-12-10 15:34:00

admin

Details Diff
0005148: Faster save performance for Configure -> Table Triggers and
Routing screens
Affected Issues
0005148
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/ITriggerRouterService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/TriggerRouterServiceSqlMap.java Diff File
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File

Issue History

Date Modified Username Field Change
2021-12-10 15:32 elong New Issue
2021-12-10 15:32 elong Status new => assigned
2021-12-10 15:32 elong Assigned To => elong
2021-12-10 15:33 elong Project SymmetricDS => SymmetricDS Pro
2021-12-10 15:34 elong Status assigned => resolved
2021-12-10 15:34 elong Resolution open => fixed
2021-12-10 15:34 elong Fixed in Version => 3.14.0
2021-12-10 16:00 admin Changeset attached => SymmetricDS 3.14 4178fe02