View Issue Details

IDProjectCategoryView StatusLast Update
0002752SymmetricDSImprovementpublic2016-08-25 19:00
Reporterelong Assigned Toelong  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.8.0 
Target Version3.8.3Fixed in Version3.8.3 
Summary0002752: Optimize DataExtractorService lookupAndOrderColumnsAccordingToTriggerHistory
DescriptionDuring load testing, it was observed that push and pulls spend a lot of time in a few methods:

* DataExtractorService.lookupAndOrderColumnsAccordingToTriggerHistory()
* TransformWriter.write()

See attached report.
TagsNo tags attached.

Activities

elong

2016-08-25 12:52

developer  

Perf.png (110,373 bytes)   
Perf.png (110,373 bytes)   

Related Changesets

SymmetricDS: 3.8 418702db

2016-08-25 08:54:13

admin

Details Diff
0002752: Optimize DataExtractorService
lookupAndOrderColumnsAccordingToTriggerHistory
Affected Issues
0002752
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/transform/TransformColumn.java Diff File
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/transform/TransformTable.java Diff File

SymmetricDS: 3.8 cf96a64b

2016-08-25 10:17:35

admin

Details Diff
0002752: Optimize DataExtractorService
lookupAndOrderColumnsAccordingToTriggerHistory
Affected Issues
0002752
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File

SymmetricDS: 3.8 94245ff5

2016-08-25 14:35:48

admin

Details Diff
0002752: Optimize DataExtractorService
lookupAndOrderColumnsAccordingToTriggerHistory
Affected Issues
0002752
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File

Issue History

Date Modified Username Field Change
2016-08-25 12:52 elong New Issue
2016-08-25 12:52 elong Status new => assigned
2016-08-25 12:52 elong Assigned To => elong
2016-08-25 12:52 elong File Added: Perf.png
2016-08-25 13:00 admin Changeset attached => SymmetricDS 3.8 418702db
2016-08-25 15:00 admin Changeset attached => SymmetricDS 3.8 cf96a64b
2016-08-25 16:55 elong Status assigned => resolved
2016-08-25 16:55 elong Fixed in Version => 3.8.3
2016-08-25 16:55 elong Resolution open => fixed
2016-08-25 19:00 admin Changeset attached => SymmetricDS 3.8 94245ff5