[
https://issues.apache.org/jira/browse/TRAFODION-2090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on TRAFODION-2090 stopped by 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
> Fix For: 2.1-incubating
>
>
> 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)
