View Issue Details

IDProjectCategoryView StatusLast Update
0001445SymmetricDSImprovementpublic2018-11-19 21:34
Reporterchenson Assigned To 
Prioritynormal 
Status closedResolutionno change required 
Product Version3.6.0 
Summary0001445: improve performance of purge queries
Descriptionhttps://sourceforge.net/p/symmetricds/discussion/739236/thread/3747ece1/

erilong - Yes, that makes sense. I would even go one step further and explicitly join sym_data_event and sym_outgoing_batch.

delete from sym_data where data_id between :min_id and :max_id and create_time < : cutoff_time and data_id in ( select e. data_id from sym_data_event e where e.data_id between :min_id and :max_id ) and not exists ( select e.data_id from sym_data_event e inner join sym_outgoing_batch b on b.batch_id = e.batch_id where e.data_id between :min_id and :max_id and b.status != 'OK' and e.data_id = sym_data.data_id)
TagsNo tags attached.

Relationships

related to 0003514 closedelong Improve purge performance of sym_data and sym_data_event 

Activities

apuma

2015-10-23 00:56

reporter   ~0000724

It's important for user of firebird with big tables to purge

gilles.riand

2017-05-04 14:24

reporter   ~0001046

Last edited: 2017-06-28 06:41

View 2 revisions

I confirm with Interbase it's the same problem. > Not Exists or NOT IN is very slow

hanes

2018-11-19 21:34

developer   ~0001348

Believed to have been done as part of 3.9 or 3.8

Issue History

Date Modified Username Field Change
2013-10-17 13:58 chenson New Issue
2013-10-17 13:58 chenson Status new => assigned
2013-10-17 13:58 chenson Assigned To => chenson
2013-11-15 12:29 chenson Project SymmetricDS Pro => SymmetricDS
2013-11-16 15:59 chenson Assigned To chenson => elong
2014-03-03 14:56 chenson Target Version 3.6.0 =>
2015-10-23 00:56 apuma Note Added: 0000724
2017-05-04 14:24 gilles.riand Note Added: 0001046
2017-06-28 06:41 gilles.riand Note Edited: 0001046 View Revisions
2018-04-09 19:23 elong Relationship added related to 0003514
2018-11-19 21:34 hanes Assigned To elong =>
2018-11-19 21:34 hanes Status assigned => closed
2018-11-19 21:34 hanes Resolution open => no change required
2018-11-19 21:34 hanes Note Added: 0001348