View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003853 | SymmetricDS | Improvement | public | 2019-01-10 14:05 | 2019-04-11 19:20 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.10.0 | ||||
| Target Version | 3.10.0 | Fixed in Version | 3.10.0 | ||
| Summary | 0003853: Defer indexes and foreign key constraints for table creation until after initial load | ||||
| Description | When 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. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.10 f38f4ccf 2019-01-10 12:58:02 Details Diff |
0003853: Defer indexes and foreign key constraints for table creation until after initial load |
Affected Issues 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 Details Diff |
0003853: Defer indexes and foreign key constraints for table creation until after initial load |
Affected Issues 0003853 |
|
| mod - symmetric-core/src/main/resources/symmetric-default.properties | Diff File | ||
|
SymmetricDS: 3.10 9a9cc305 2019-02-25 13:56:43 Details Diff |
0003853: Defer indexes and foreign key constraints for table creation |
Affected Issues 0003853 |
|
| 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/java/org/jumpmind/symmetric/service/impl/RouterService.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-01-10 14:05 | elong | New Issue | |
| 2019-01-10 14:05 | elong | Status | new => assigned |
| 2019-01-10 14:05 | elong | Assigned To | => elong |
| 2019-01-10 18:00 | admin | Changeset attached | => SymmetricDS 3.10 f38f4ccf |
| 2019-01-10 23:36 | elong | Status | assigned => resolved |
| 2019-01-10 23:36 | elong | Resolution | open => fixed |
| 2019-01-10 23:36 | elong | Fixed in Version | => 3.10.0 |
| 2019-01-11 18:00 | admin | Changeset attached | => SymmetricDS 3.10 d15cd722 |
| 2019-02-25 19:00 | admin | Changeset attached | => SymmetricDS 3.10 9a9cc305 |
| 2019-03-14 12:48 | admin | Status | resolved => closed |
| 2019-04-11 19:20 | elong | Relationship added | related to 0001341 |