[jira] [Assigned] (TRAFODION-2090) improve the very first time of query compiling

["liu ming (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-2090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

liu ming reassigned TRAFODION-2090:
-----------------------------------

    Assignee: liu ming

> improve the very first time of query compiling
> ----------------------------------------------
>
>                 Key: TRAFODION-2090
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2090
>             Project: Apache Trafodion
>          Issue Type: Improvement
>            Reporter: liu ming
>            Assignee: liu ming
>
> Currently, the very first query run in master executor: sqlci or mxosrvr will take seconds to compile. 
> Initial analysis shows most time spend on metadata retrieving.
> Need to improve the compile time for the very first time, at least from end user's perspective.
> Speed up the metadata retrieval speed.
> Redesign metadata scheme
> Prefetch metadata
> are all among possible solutions, the aim is to shorten the time spend on the SQL compile for the first time. Initial goal is within 1 second, faster the better.



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