View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005148 | SymmetricDS Pro | Improvement | public | 2021-12-10 15:32 | 2022-07-27 20:54 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.14.0 | ||||
| Target Version | 3.14.0 | Fixed in Version | 3.14.0 | ||
| Summary | 0005148: Faster save performance for Configure -> Table Triggers and Routing screens | ||||
| Description | Improve 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. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.14 4178fe02 2021-12-10 15:34:00 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 | ||
| 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 |
| 2022-07-27 20:54 | admin | Status | resolved => closed |