View Issue Details

IDProjectCategoryView StatusLast Update
0004227SymmetricDSImprovementpublic2020-01-23 20:42
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.11.0 
Target Version3.11.4Fixed in Version3.11.4 
Summary0004227: Data gap detector should use batch mode to insert and delete sym_data_gap
DescriptionUse JDBC batch mode to send multiple insert or delete statements to the database when updating the sym_data_gap table. This will improve performance on systems with lots of data gaps from high contention, rollbacks, or disabled/slow channels.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.11 f3bdd938

2020-01-03 09:21:30

admin

Details Diff
0004227: Data gap detector should use batch mode to insert and delete
sym_data_gap
Affected Issues
0004227
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/DataGapFastDetector.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/IDataService.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataService.java Diff File
mod - symmetric-core/src/test/java/org/jumpmind/symmetric/route/DataGapDetectorTest.java Diff File

SymmetricDS: 3.11 2a7af104

2020-01-03 19:52:32

admin

Details Diff
0004227: cleanup, get batch algo once for channel Affected Issues
0004227
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/route/ChannelRouterContext.java Diff File
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/RouterService.java Diff File

SymmetricDS: 3.11 d1802ee6

2020-01-03 20:00:10

admin

Details Diff
0004227: cleanup for tests Affected Issues
0004227
mod - symmetric-core/src/test/java/org/jumpmind/symmetric/route/DataGapRouteReaderTest.java Diff File
mod - symmetric-core/src/test/java/org/jumpmind/symmetric/service/impl/AbstractRouterServiceTest.java Diff File

Issue History

Date Modified Username Field Change
2020-01-03 14:20 elong New Issue
2020-01-03 14:20 elong Status new => assigned
2020-01-03 14:20 elong Assigned To => elong
2020-01-03 14:22 elong Status assigned => resolved
2020-01-03 14:22 elong Resolution open => fixed
2020-01-03 14:22 elong Fixed in Version => 3.11.4
2020-01-03 15:00 admin Changeset attached => SymmetricDS 3.11 f3bdd938
2020-01-04 01:00 admin Changeset attached => SymmetricDS 3.11 2a7af104
2020-01-04 02:00 admin Changeset attached => SymmetricDS 3.11 d1802ee6
2020-01-23 20:42 admin Status resolved => closed