You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "liu ming (JIRA)" <ji...@apache.org> on 2016/06/30 13:53:10 UTC

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

liu ming created TRAFODION-2090:
-----------------------------------

             Summary: 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


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)