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)

Reply via email to