View Issue Details

IDProjectCategoryView StatusLast Update
0005840SymmetricDSImprovementpublic2023-05-17 12:27
Reporterelong Assigned Toelong  
Status resolvedResolutionfixed 
Product Version3.15.0 
Target Version3.15.0Fixed in Version3.15.0 
Summary0005840: Purge should use "exists" clause instead of "in" clause for performance
DescriptionModify purge service to use "exists" clause for deletes that correlate a sub-query with other tables. The "exists" clause has better performance when many rows are involved. The purge service currently uses "in" clauses to join other tables, which is compatible with most databases. Add a canDeleteUsingExists property to DatabaseInfo that can be set to false for the old behavior. MySQL 5.7 and earlier needs to use "in" clauses for deletes.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2023-05-17 12:07 elong New Issue
2023-05-17 12:07 elong Status new => assigned
2023-05-17 12:07 elong Assigned To => elong
2023-05-17 12:07 elong Tag Attached: purge
2023-05-17 12:11 elong Summary Purge can use "exists" clause instead "in" clause for performance => Purge should use "exists" clause instead of "in" clause for performance
2023-05-17 12:27 elong Status assigned => resolved
2023-05-17 12:27 elong Resolution open => fixed
2023-05-17 12:27 elong Fixed in Version => 3.15.0