View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0003757SymmetricDSImprovementpublic2018-10-12 19:192019-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