View Issue Details

IDProjectCategoryView StatusLast Update
0006069SymmetricDSImprovementpublic2023-10-30 15:08
Reporterelong Assigned Toelong  
Status closedResolutionfixed 
Product Version3.15.0 
Target Version3.15.1Fixed in Version3.15.1 
Summary0006069: Slow extract and load when using $(targetExternalId) variable
DescriptionThe $(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.
Tagsdata sync, extract


related to 0006064 closedelong Slow extract and load when using $(targetExternalId) variable 


There are no notes attached to this issue.

Issue History

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