{"action":"opened","issue":{"url":"https://api.github.com/repos/orientechnologies/orientdb/issues/8156","repository_url":"https://api.github.com/repos/orientechnologies/orientdb","labels_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/8156/labels{/name}","comments_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/8156/comments","events_url":"https://api.github.com/repos/orientechnologies/orientdb/issues/8156/events","html_url":"https://github.com/orientechnologies/orientdb/issues/8156","id":305076924,"number":8156,"title":"How to query cluster's records count with SQL","user":{"login":"robben766","id":12017726,"avatar_url":"https://avatars1.githubusercontent.com/u/12017726?v=4","gravatar_id":"","url":"https://api.github.com/users/robben766","html_url":"https://github.com/robben766","followers_url":"https://api.github.com/users/robben766/followers","following_url":"https://api.github.com/users/robben766/following{/other_user}","gists_url":"https://api.github.com/users/robben766/gists{/gist_id}","starred_url":"https://api.github.com/users/robben766/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robben766/subscriptions","organizations_url":"https://api.github.com/users/robben766/orgs","repos_url":"https://api.github.com/users/robben766/repos","events_url":"https://api.github.com/users/robben766/events{/privacy}","received_events_url":"https://api.github.com/users/robben766/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-03-14T09:16:53Z","updated_at":"2018-03-14T09:16:53Z","closed_at":null,"author_association":"NONE","body":"### OrientDB Version: 2.2.15\r\n### Java Version: 1.8\r\n### OS: CentOS 7 \r\nI need query cluster's records count with SQL，use “selec count(*) from foo where @rid like '#10:%' ” is fine in little data. But in big data , will be very slow\r\n## Description\r\n1.I have about 1,000,000 record In foo\r\n2. I use this sql \r\n'''\r\nselec count(*) from foo where @rid like '#10:%' \r\n'''\r\nand I got this result\r\n'''\r\nQuery executed in 35.095 sec. Returned 1 record(s)\r\n'''\r\nAny suggestions ?"}}
{"actor":{"display_login":"robben766"}}