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)