View Issue Details

IDProjectCategoryView StatusLast Update
0002803SymmetricDSBugpublic2016-09-29 21:01
ReporterchensonAssigned Tochenson 
PriorityhighSeverityminorReproducibilitysometimes
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.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.8 161b8f73

2016-09-18 12:03:01

chenson

Details Diff
0002803: Outgoing purge job is slower than it needs to be
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

Issue History

Date Modified Username Field Change
2016-09-18 12:00 chenson New Issue
2016-09-18 12:00 chenson Status new => assigned
2016-09-18 12:00 chenson Assigned To => chenson
2016-09-18 12:03 chenson Status assigned => resolved
2016-09-18 12:03 chenson Fixed in Version => 3.8.5
2016-09-18 12:03 chenson Resolution open => fixed
2016-09-18 13:00 chenson Changeset attached => SymmetricDS 3.8 161b8f73
2016-09-29 21:01 admin Status resolved => closed