[jira] [Commented] (KYLIN-2325) kylin sql optimization is very slow about 100ms or so, and consumes a lot of cpu
[ https://issues.apache.org/jira/browse/KYLIN-2325?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16270240#comment-16270240 ] Shaofeng SHI commented on KYLIN-2325: - Please provide more information like sample sql, profiling statistics for the developer to understand the scenario. Not everyone can understand the problem quickly. > kylin sql optimization is very slow about 100ms or so, and consumes a lot of > cpu > > > Key: KYLIN-2325 > URL: https://issues.apache.org/jira/browse/KYLIN-2325 > Project: Kylin > Issue Type: Improvement >Reporter: WangTaiZe > Labels: performance > Original Estimate: 12h > Remaining Estimate: 12h > > kylin sql optimization is too slow, and consumes too much cpu. -- This message was sent by Atlassian JIRA (v6.4.14#64029)
[jira] [Commented] (KYLIN-2325) kylin sql optimization is very slow about 100ms or so, and consumes a lot of cpu
[ https://issues.apache.org/jira/browse/KYLIN-2325?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15878494#comment-15878494 ] Billy Liu commented on KYLIN-2325: -- Hi [~elasticlog], are you talking about this https://issues.apache.org/jira/browse/KYLIN-2001 > kylin sql optimization is very slow about 100ms or so, and consumes a lot of > cpu > > > Key: KYLIN-2325 > URL: https://issues.apache.org/jira/browse/KYLIN-2325 > Project: Kylin > Issue Type: Improvement >Reporter: WangTaiZe > Labels: performance > Fix For: v2.0.0 > > Original Estimate: 12h > Remaining Estimate: 12h > > kylin sql optimization is too slow, and consumes too much cpu. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (KYLIN-2325) kylin sql optimization is very slow about 100ms or so, and consumes a lot of cpu
[ https://issues.apache.org/jira/browse/KYLIN-2325?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15874065#comment-15874065 ] liyang commented on KYLIN-2325: --- > Can we add the results of optimizing sql to cache for reuse? Of course we can. However, I don't see SQL optimization a bottleneck for most users yet. Why you think it is bottleneck? Any numbers? > kylin sql optimization is very slow about 100ms or so, and consumes a lot of > cpu > > > Key: KYLIN-2325 > URL: https://issues.apache.org/jira/browse/KYLIN-2325 > Project: Kylin > Issue Type: Improvement >Reporter: WangTaiZe > Labels: performance > Fix For: v2.0.0 > > Original Estimate: 12h > Remaining Estimate: 12h > > kylin sql optimization is too slow, and consumes too much cpu. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (KYLIN-2325) kylin sql optimization is very slow about 100ms or so, and consumes a lot of cpu
[ https://issues.apache.org/jira/browse/KYLIN-2325?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15860803#comment-15860803 ] WangTaiZe commented on KYLIN-2325: -- In some scenarios, the time of querying storage may take only a few milliseconds, but optimizing sql consumes a hundred milliseconds. Can we add the results of optimizing sql to cache for reuse? > kylin sql optimization is very slow about 100ms or so, and consumes a lot of > cpu > > > Key: KYLIN-2325 > URL: https://issues.apache.org/jira/browse/KYLIN-2325 > Project: Kylin > Issue Type: Improvement >Reporter: WangTaiZe > Labels: performance > Fix For: v2.0.0 > > Original Estimate: 12h > Remaining Estimate: 12h > > kylin sql optimization is too slow, and consumes too much cpu. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (KYLIN-2325) kylin sql optimization is very slow about 100ms or so, and consumes a lot of cpu
[ https://issues.apache.org/jira/browse/KYLIN-2325?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15857546#comment-15857546 ] liyang commented on KYLIN-2325: --- Hi [~elasticlog], thanks for bring up this topic. 100ms is not much in big data scenario and it's meant to use CPU. That said, what is your requirement regarding the SQL parsing performance? Why is 100ms a concern? Is it a bottleneck in your env? Any performance goal you want to achieve? Please share more background. > kylin sql optimization is very slow about 100ms or so, and consumes a lot of > cpu > > > Key: KYLIN-2325 > URL: https://issues.apache.org/jira/browse/KYLIN-2325 > Project: Kylin > Issue Type: Improvement >Reporter: WangTaiZe > Labels: performance > Fix For: v2.0.0 > > Original Estimate: 12h > Remaining Estimate: 12h > > kylin sql optimization is too slow, and consumes too much cpu. -- This message was sent by Atlassian JIRA (v6.3.15#6346)