View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006069 | SymmetricDS | Improvement | public | 2023-10-30 15:00 | 2023-10-30 15:08 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.15.0 | ||||
| Target Version | 3.15.1 | Fixed in Version | 3.15.1 | ||
| Summary | 0006069: Slow extract and load 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. Extract and load look up the table definition for each row change encountered. Extract needs the table definition to support the stream LOB feature. Load needs the table definition for data type binding on DML statements. When so many different tables are being extracted and routed, it becomes expensive to look up each table definition. When using $(targetExternalId), extract and load should cache the first table definition found and assume all other expanded nodes are the same. | ||||
| Tags | data sync, extract | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-10-30 15:00 | elong | New Issue | |
| 2023-10-30 15:00 | elong | Status | new => assigned |
| 2023-10-30 15:00 | elong | Assigned To | => elong |
| 2023-10-30 15:00 | elong | Tag Attached: data sync | |
| 2023-10-30 15:00 | elong | Tag Attached: extract | |
| 2023-10-30 15:00 | elong | Issue generated from: 0006064 | |
| 2023-10-30 15:00 | elong | Relationship added | related to 0006064 |
| 2023-10-30 15:08 | elong | Status | assigned => resolved |
| 2023-10-30 15:08 | elong | Resolution | open => fixed |
| 2023-10-30 15:08 | elong | Fixed in Version | => 3.15.1 |
| 2023-11-14 21:10 | admin | Status | resolved => closed |