View Issue Details

IDProjectCategoryView StatusLast Update
0003853SymmetricDSImprovementpublic2019-01-11 13:00
ReporterelongAssigned Toelong 
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.10.0 
Target Version3.10.0Fixed in Version3.10.0 
Summary0003853: Defer indexes and foreign key constraints for table creation until after initial load
DescriptionWhen the user requests table to be created as part of the initial load, create the table without foreign keys and indexes so the load will perform better. After each table is extracted, queue another table creation -- this time on the regular channel for the trigger -- that will alter the table to add foreign keys and indexes. By queuing the alters on the regular channel instead of the reload channel, the change capture should bring the table into consistency. Allow enable/disable with parameter initial.load.defer.create.constraints=true.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.10 f38f4ccf

2019-01-10 12:58:02

admin

Details Diff
0003853: Defer indexes and foreign key constraints for table creation
until after initial load

0003853
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/common/ParameterConstants.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/IDataService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataServiceSqlMap.java Diff File
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File

SymmetricDS: 3.10 d15cd722

2019-01-11 12:17:36

admin

Details Diff
0003853: Defer indexes and foreign key constraints for table creation
until after initial load

0003853
mod - symmetric-core/src/main/resources/symmetric-default.properties Diff File

Issue History

Date Modified Username Field Change
2019-01-10 09:05 elong New Issue
2019-01-10 09:05 elong Status new => assigned
2019-01-10 09:05 elong Assigned To => elong
2019-01-10 13:00 admin Changeset attached => SymmetricDS 3.10 f38f4ccf
2019-01-10 18:36 elong Status assigned => resolved
2019-01-10 18:36 elong Resolution open => fixed
2019-01-10 18:36 elong Fixed in Version => 3.10.0
2019-01-11 13:00 admin Changeset attached => SymmetricDS 3.10 d15cd722