[ 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)