[ 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)