Vladimir Ozerov commented on IGNITE-7167:

[~vkulichenko], {{IgniteCache.size}} is not appropriate for two reasons:
1) We still allow for multiple tables in the same cache, so {{size()}} will 
return number of entries from all tables
2) It doesn't work for MVCC case

> Optimize 'select count(*) from Table'
> -------------------------------------
>                 Key: IGNITE-7167
>                 URL: https://issues.apache.org/jira/browse/IGNITE-7167
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>    Affects Versions: 2.3
>            Reporter: Valentin Kulichenko
>            Priority: Major
> Currently query like {{select count(*) from Table}} effectively scans the 
> cache and take a lot of time for large datasets. Probably makes sense to 
> optimize it to use {{IgniteCache#size}} directly when possible.

This message was sent by Atlassian JIRA

Reply via email to