[
https://issues.apache.org/jira/browse/TRAFODION-2949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sandhya Sundaresan reassigned TRAFODION-2949:
---------------------------------------------
Assignee: taian.wei (was: Sandhya Sundaresan)
> 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: taian.wei
> 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)
