You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Sandhya Sundaresan (JIRA)" <ji...@apache.org> on 2018/04/23 21:15:00 UTC
[jira] [Updated] (TRAFODION-2949) LOB: Address performance issues
related to inserts/extracts in tables containing LOB columns
[ https://issues.apache.org/jira/browse/TRAFODION-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sandhya Sundaresan updated TRAFODION-2949:
------------------------------------------
Summary: LOB: Address performance issues related to inserts/extracts in tables containing LOB columns (was: LOB: Address performance issues related to inserts in tables containing LOB columns)
> LOB: Address performance issues related to inserts/extracts in tables containing LOB columns
> --------------------------------------------------------------------------------------------
>
> Key: TRAFODION-2949
> URL: https://issues.apache.org/jira/browse/TRAFODION-2949
> Project: Apache Trafodion
> Issue Type: Improvement
> Reporter: Sandhya Sundaresan
> Assignee: Sandhya Sundaresan
> Priority: Major
>
> # Investigate bottlenecks in the insert and update code paths.
> A couple of bottlenecks identified initially were hdfsWrite and the LOBCLi call.
> # Investigate if lib hdfs write operation is signifincantly slower than a direct JNI call. If so consider refactoring code being done for hive inserts and reuse for LOB writes as well. Also investigate use of libhdfs3 , a lightweight interface by Pivotal for Hawk ,that doesn’t use JNI at all.
> # Investigate if LOB Cli calls that do prepare and execute of statements to insert/update the LOB descriptor tables are being cached and reused when multiple LOB inserts are being done in the same session.
> # Investigate external LOBs as a solution for faster inserts/extracts for usage compared to internal LOBs.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)