View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002803 | SymmetricDS | Bug | public | 2016-09-18 16:00 | 2016-09-30 01:01 |
| Reporter | chenson | Assigned To | chenson | ||
| Priority | high | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 3.8.4 | ||||
| Target Version | 3.8.5 | Fixed in Version | 3.8.5 | ||
| Summary | 0002803: Outgoing purge job is slower than it needs to be | ||||
| Description | The stranded data purge process uses a sub query to get the minimum start_id in sym_data_gap. It will be much faster to query that value once and bind it in. On a customer's sql server system a single delete statement went from 700ms to 14ms. | ||||
| Tags | No tags attached. | ||||
|
SymmetricDS: 3.8 161b8f73 2016-09-18 12:03:01 Details Diff |
0002803: Outgoing purge job is slower than it needs to be |
Affected Issues 0002803 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/PurgeServiceSqlMap.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-09-18 16:00 | chenson | New Issue | |
| 2016-09-18 16:00 | chenson | Status | new => assigned |
| 2016-09-18 16:00 | chenson | Assigned To | => chenson |
| 2016-09-18 16:03 | chenson | Status | assigned => resolved |
| 2016-09-18 16:03 | chenson | Fixed in Version | => 3.8.5 |
| 2016-09-18 16:03 | chenson | Resolution | open => fixed |
| 2016-09-18 17:00 | chenson | Changeset attached | => SymmetricDS 3.8 161b8f73 |
| 2016-09-30 01:01 | admin | Status | resolved => closed |