[ 
https://issues.apache.org/jira/browse/IGNITE-13068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17210767#comment-17210767
 ] 

alfie. commented on IGNITE-13068:
---------------------------------

[~tledkov-gridgain] hi,I met a problem witch may relate to your patch in 2.8.1. 
when i query counts from a big data set. the table need to refresh stats by 
scan the whole index. this may cost hours of time. my whole index are Hundreds 
of millions.  May I inquire is this patch has resolved my problem?

> SQL: use cache.localSize instead of index scan to calculate row count 
> statistic 
> --------------------------------------------------------------------------------
>
>                 Key: IGNITE-13068
>                 URL: https://issues.apache.org/jira/browse/IGNITE-13068
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>            Reporter: Taras Ledkov
>            Assignee: Taras Ledkov
>            Priority: Major
>             Fix For: 2.9
>
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> The scan of index is slow on big data set on setup where disc i/o requires 
> warm up.
> This is the reason that restarting the node can take a long time.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to