View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001445 | SymmetricDS | Improvement | public | 2013-10-17 13:58 | 2018-11-19 21:34 |
| Reporter | chenson | Assigned To | |||
| Priority | normal | ||||
| Status | closed | Resolution | no change required | ||
| Product Version | 3.6.0 | ||||
| Summary | 0001445: improve performance of purge queries | ||||
| Description | https://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) | ||||
| Tags | No tags attached. | ||||
|
|
It's important for user of firebird with big tables to purge |
|
|
I confirm with Interbase it's the same problem. > Not Exists or NOT IN is very slow |
|
|
Believed to have been done as part of 3.9 or 3.8 |
| 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 |