View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0007099 | SymmetricDS | Improvement | public | 2025-10-22 17:27 | 2025-10-22 20:47 |
| Reporter | mdrouard | Assigned To | |||
| Priority | normal | ||||
| Status | acknowledged | Resolution | open | ||
| Product Version | 3.16.8 | ||||
| Summary | 0007099: Optimize Full Load by sending index definitions before the Finalize batch is sent | ||||
| Description | The fix for issue 0007098 forced full loads to always sort tables by FK order, which slows the initial processing down. Sometimes this slowdown is significant! To optimize a Full Load SymmetricDS could send index definitions before the Finalize batch is sent, right after all load-related data batches are sent. | ||||
| Tags | No tags attached. | ||||
|
|
Currently Symmetric will always sort by FK during initial load changed in the following PR https://github.com/jumpmindinc/symmetric-ds/pull/413 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-10-22 17:27 | mdrouard | New Issue | |
| 2025-10-22 17:28 | mdrouard | Relationship added | related to 0007098 |
| 2025-10-22 17:44 | mdrouard | Description Updated | View Revisions |
| 2025-10-22 18:05 | mdrouard | Description Updated | View Revisions |
| 2025-10-22 18:29 | pbelov | Summary | Symmetric will always sort by FK order when sending an initial load => Optimize Full Load by sending index definitions before the Finalize batch is sent |
| 2025-10-22 18:29 | pbelov | Description Updated | View Revisions |
| 2025-10-22 20:47 | mdrouard | Status | new => acknowledged |
| 2025-10-22 20:47 | mdrouard | Note Added: 0003512 |