View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005780 | SymmetricDS | Improvement | public | 2023-04-07 20:13 | 2023-10-30 13:29 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.14.0 | ||||
| Target Version | 3.14.7 | Fixed in Version | 3.14.7 | ||
| Summary | 0005780: Slow routing when using $(targetExternalId) variable | ||||
| Description | The $(targetExternalId) variable is used to match tables by node when multi-homing a copy of the tables for each node at a central database. Routing looks up the table definition for each row change it encounters, because the column types are sometimes used by routers, like bsh, audit, and subselect routers. But when so many different tables are being routed, it becomes expensive to look up each table definition. When using $(targetExternalId), routing should either skip the table lookup or lookup the table for the first node. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.14 014042b3 2023-04-14 20:33:44 Details Diff |
0005780: Slow routing when using $(targetExternalId) variable |
Affected Issues 0005780 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/cache/CacheManager.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/cache/ICacheManager.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/cache/TriggerRouterCache.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/AbstractDataGapRouteCursor.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/ChannelRouterContext.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/DataGapRouteMultiCursor.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/RouterService.java | Diff File | ||
|
SymmetricDS: 3.15 1c947e70 2023-04-14 20:33:44 Details Diff |
0005780: Slow routing when using $(targetExternalId) variable |
Affected Issues 0005780 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/cache/CacheManager.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/cache/ICacheManager.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/cache/TriggerRouterCache.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/ChannelRouterContext.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/RouterService.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-04-07 20:13 | elong | New Issue | |
| 2023-04-07 20:13 | elong | Status | new => assigned |
| 2023-04-07 20:13 | elong | Assigned To | => elong |
| 2023-04-14 20:33 | elong | Status | assigned => resolved |
| 2023-04-14 20:33 | elong | Resolution | open => fixed |
| 2023-04-14 20:33 | elong | Fixed in Version | => 3.14.7 |
| 2023-04-14 21:00 | admin | Changeset attached | => SymmetricDS 3.14 014042b3 |
| 2023-05-12 19:49 | admin | Status | resolved => closed |
| 2023-10-03 23:00 | admin | Changeset attached | => SymmetricDS 3.15 1c947e70 |
| 2023-10-30 13:29 | elong | Relationship added | related to 0006064 |