View Issue Details

IDProjectCategoryView StatusLast Update
0000344SymmetricDSImprovementpublic2010-01-25 12:54
ReporterAssigned Tochenson  
Priorityhigh 
Status closedResolutionfixed 
Product Version2.1.0 
Target Version2.1.1Fixed in Version2.1.1 
Summary0000344: Improve performance of sym_data select on oracle by adding option to use dbms_lob.substr( sqltext, 4000, 1 ) at the channel leve
DescriptionThe issue is that Oracle makes a call back to the database for every lob field for every row. Because sym_data has three lobs, for every row that is extracted for either transport or routing the jdbc driver makes three calls back to the database. If the dbms_lob.substr function is used, then the values are streamed with the rest of the result set. The downside of this approach is that the data is limited to 4000 characters. As long as we have a good error message and the ability to turn this off at the channel level I think this is acceptable. Add a contains_large_lobs column on sym_channel. Default it to 0. If 0, then use the lob substring method in the data extraction and data routing queries.
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change