[ 
https://issues.apache.org/jira/browse/TRAFODION-2137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15404843#comment-15404843
 ] 

ASF GitHub Bot commented on TRAFODION-2137:
-------------------------------------------

Github user DaveBirdsall commented on a diff in the pull request:

    https://github.com/apache/incubator-trafodion/pull/634#discussion_r73241623
  
    --- Diff: core/sql/arkcmp/CmpStoredProc.cpp ---
    @@ -363,7 +361,7 @@ NABoolean 
CmpSPOutputFormat::getColumnDesc(SP_FIELDDESC_STRUCT* fDesc,
         {
           // convert ElemDDLColViewDef into CatColumn, then column_desc
           if ( !ElemDDLColDef2ColumnDescStruct
    -      (elemDDL, tableDesc_->body.table_desc.tablename, colsDesc) )
    +      (elemDDL, tableDesc_->tableDesc()->tablename, colsDesc) )
    --- End diff --
    
    Why not make tableDesc_ an object of type TrafTableDesc * and skip the cast?


> Improve metadata access time during query compilation
> -----------------------------------------------------
>
>                 Key: TRAFODION-2137
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2137
>             Project: Apache Trafodion
>          Issue Type: Improvement
>            Reporter: Anoop Sharma
>            Assignee: Anoop Sharma
>
> When a trafodion object is accessed for the first time in a session, 
> information about it is read from metadata.
> Multiple metadata tables are read to retrieve information about the
> objects being used in the query.
> Once metadata info is read about a table, it is cached in compiler memory. 
> Another query accessing the same object gets it from compiler metadata
> cache.
> This results in the first query compile performance to be slower than the
> subsequent queries accessing the same objects.
> This JIRA is to improve performance of first access of an object in
> a query.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to