View Issue Details

IDProjectCategoryView StatusLast Update
0002803SymmetricDSBugpublic2016-09-30 01:01
Reporterchenson Assigned Tochenson  
Status closedResolutionfixed 
Product Version3.8.4 
Target Version3.8.5Fixed in Version3.8.5 
Summary0002803: Outgoing purge job is slower than it needs to be
DescriptionThe 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.
TagsNo tags attached.


There are no notes attached to this issue.

Related Changesets

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
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/ Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/ Diff File

Issue History

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