[
https://issues.apache.org/jira/browse/KYLIN-4670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhong Yanghong updated KYLIN-4670:
----------------------------------
Attachment: (was: Single-Thread-Second-Time.png)
> Improve query performance by reusing LookupStringTable and using multi-threads
> ------------------------------------------------------------------------------
>
> Key: KYLIN-4670
> URL: https://issues.apache.org/jira/browse/KYLIN-4670
> Project: Kylin
> Issue Type: Improvement
> Reporter: Zhong Yanghong
> Assignee: Zhong Yanghong
> Priority: Major
> Attachments: Five-Threads-First-Time.png,
> Five-Threads-Second-Time.png, Single-Thread-First-Time.png,
> Single-Thread-Second-Time.png
>
>
> For a cube with 37 segments and related snapshots are all different from each
> other. Do a query with lookup table derived column. Here's the performance
> comparison between single thread & five threads.
> * For the first time query without snapshot table cache:
> ** Single Thread
> !Single-Thread-First-Time.png|width=600,height=200!
> ** Five Threads
> !Five-Threads-First-Time.png|width=600,height=200!
> * For the second time query with snapshot table cache:
> ** Single Thread
> !Single-Thread-Second-Time.png|width=600,height=200!
> ** Five Threads
> !Five-Threads-Second-Time.png|width=600,height=200!
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
