[
https://issues.apache.org/jira/browse/IGNITE-7167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16360409#comment-16360409
]
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
(v7.6.3#76005)
