You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ignite.apache.org by "Valentin Kulichenko (JIRA)" <ji...@apache.org> on 2017/12/11 21:42:00 UTC

[jira] [Created] (IGNITE-7167) Optimize 'select count(*) from Table'

Valentin Kulichenko created IGNITE-7167:
-------------------------------------------

             Summary: 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


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
(v6.4.14#64029)