View Issue Details

IDProjectCategoryView StatusLast Update
0003757SymmetricDSImprovementpublic2018-11-28 11:00
ReporterelongAssigned Toelong 
Prioritynormal 
Status resolvedResolutionfixed 
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.

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

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 15:19 elong New Issue
2018-10-12 15:19 elong Status new => assigned
2018-10-12 15:19 elong Assigned To => elong
2018-10-12 15:25 elong Status assigned => resolved
2018-10-12 15:25 elong Resolution open => fixed
2018-10-12 15:25 elong Fixed in Version => 3.10.0
2018-11-28 11:00 admin Changeset attached => SymmetricDS 3.10 86cc0ed8