View Issue Details

IDProjectCategoryView StatusLast Update
0003757SymmetricDSImprovementpublic2019-03-14 12:48
Reporterelong Assigned Toelong  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.10.0 
Target Version3.10.0Fixed in Version3.10.0 
Summary0003757: Stream LOB uses multiple queries per row when a table has multiple LOB columns
DescriptionWhen the sym_trigger.stream_lob = 1 feature is enabled, it will query the LOB columns during extraction, but it runs a query for each LOB column. A table with multiple LOB columns will be penalized with multiple queries. Query all LOB columns once for each row.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.10 86cc0ed8

2018-10-12 15:25:00

admin

Details Diff
0003757: Stream LOB uses multiple queries per row when a table has
multiple LOB columns
Affected Issues
0003757
mod - symmetric-io/src/main/java/org/jumpmind/symmetric/io/data/reader/ExtractDataReader.java Diff File

Issue History

Date Modified Username Field Change
2018-10-12 19:19 elong New Issue
2018-10-12 19:19 elong Status new => assigned
2018-10-12 19:19 elong Assigned To => elong
2018-10-12 19:25 elong Status assigned => resolved
2018-10-12 19:25 elong Resolution open => fixed
2018-10-12 19:25 elong Fixed in Version => 3.10.0
2018-11-28 16:00 admin Changeset attached => SymmetricDS 3.10 86cc0ed8
2019-03-14 12:48 admin Status resolved => closed