View Issue Details

IDProjectCategoryView StatusLast Update
0004066SymmetricDSImprovementpublic2019-08-23 16:46
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.10.0 
Target Version3.10.4Fixed in Version3.10.4 
Summary0004066: Potential bottleneck from counting commas in rows of initial load
DescriptionThe initial load is currently counting the commas in each row returned, which has shown up in thread dumps indicating it may be a hotspot. If the initial.load.concat.csv.in.sql.enabled parameter is true, the comma counting is used to detected when a row exceeds the VARCHAR limit of the platform. We default the parameter to false in 3.10, so columns are selected individually, and we can skip the comma counting in that case.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.10 33c62f3c

2019-08-09 08:59:42

admin

Details Diff
0004066: Potential bottleneck from counting commas in rows of initial
load
Affected Issues
0004066
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/DataExtractorService.java Diff File

Issue History

Date Modified Username Field Change
2019-08-09 12:50 elong New Issue
2019-08-09 12:50 elong Status new => assigned
2019-08-09 12:50 elong Assigned To => elong
2019-08-09 13:00 admin Changeset attached => SymmetricDS 3.10 33c62f3c
2019-08-09 13:04 elong Status assigned => resolved
2019-08-09 13:04 elong Resolution open => fixed
2019-08-09 13:04 elong Fixed in Version => 3.10.4
2019-08-23 16:46 admin Status resolved => closed