[jira] [Created] (TRAFODION-2949) LOB: Address performance issues related to inserts in tables containing LOB columns

["Sandhya Sundaresan (JIRA)" <ji...@apache.org>]

Sandhya Sundaresan created TRAFODION-2949:
---------------------------------------------

             Summary: LOB: Address performance issues related to inserts 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


# 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)