[
https://issues.apache.org/jira/browse/PHOENIX-6012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17157962#comment-17157962
]
Chen Feng commented on PHOENIX-6012:
------------------------------------
In our environment, SYSTEM.STATS for TABLE_X has over 10,000 lines. Executing
GuidePostsCache$StatsLoader.load() can cost tens of seconds.
A simple method is disable the access of guide posts in
BaseResultIterators.useStats() by adding configuration in Connection.
> make USE_OF_QUERY_GUIDE_POSTS configurable to improve query performance.
> ------------------------------------------------------------------------
>
> Key: PHOENIX-6012
> URL: https://issues.apache.org/jira/browse/PHOENIX-6012
> Project: Phoenix
> Issue Type: Improvement
> Reporter: Chen Feng
> Priority: Minor
>
> Loading guide posts from SYSTEM.STATS can cost lots of time.
> When we have knowledge of the data size covered by query scan, we can disable
> the use of guide posts to improve query performance.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
