{"action":"created","issue":{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/4722","repository_url":"https://api.github.com/repos/rethinkdb/rethinkdb","labels_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/4722/labels{/name}","comments_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/4722/comments","events_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/4722/events","html_url":"https://github.com/rethinkdb/rethinkdb/issues/4722","id":101803687,"number":4722,"title":"Very slow query performance using orderBy","user":{"login":"nodesocket","id":523312,"avatar_url":"https://avatars.githubusercontent.com/u/523312?v=3","gravatar_id":"","url":"https://api.github.com/users/nodesocket","html_url":"https://github.com/nodesocket","followers_url":"https://api.github.com/users/nodesocket/followers","following_url":"https://api.github.com/users/nodesocket/following{/other_user}","gists_url":"https://api.github.com/users/nodesocket/gists{/gist_id}","starred_url":"https://api.github.com/users/nodesocket/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nodesocket/subscriptions","organizations_url":"https://api.github.com/users/nodesocket/orgs","repos_url":"https://api.github.com/users/nodesocket/repos","events_url":"https://api.github.com/users/nodesocket/events{/privacy}","received_events_url":"https://api.github.com/users/nodesocket/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":18,"created_at":"2015-08-19T04:15:40Z","updated_at":"2016-02-05T21:09:15Z","closed_at":null,"body":"Running `RethinkDB 2.1.1` on 3 servers *(each with 2 cores and 13GB of memory)*. The table `daily_quotes` has 3 shards and 3 replicas. Each shard has around 22,000 documents. There is a secondary index on `date`.\r\n\r\nRunning a simple query:\r\n\r\n    r.db('macd').table('daily_quotes').orderBy('date')\r\n\r\nTakes over 23 seconds. I ran a query profile and see:\r\n\r\n    23.32s round-trip time\r\n    10.87s server time\r\n    312 shard accesses\r\n\r\nAnd here is the raw query profile json:\r\n\r\n**REMOVED JSON BECAUSE IT WAS HUGE**"},"comment":{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/comments/180554579","html_url":"https://github.com/rethinkdb/rethinkdb/issues/4722#issuecomment-180554579","issue_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/4722","id":180554579,"user":{"login":"danielmewes","id":505365,"avatar_url":"https://avatars.githubusercontent.com/u/505365?v=3","gravatar_id":"","url":"https://api.github.com/users/danielmewes","html_url":"https://github.com/danielmewes","followers_url":"https://api.github.com/users/danielmewes/followers","following_url":"https://api.github.com/users/danielmewes/following{/other_user}","gists_url":"https://api.github.com/users/danielmewes/gists{/gist_id}","starred_url":"https://api.github.com/users/danielmewes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/danielmewes/subscriptions","organizations_url":"https://api.github.com/users/danielmewes/orgs","repos_url":"https://api.github.com/users/danielmewes/repos","events_url":"https://api.github.com/users/danielmewes/events{/privacy}","received_events_url":"https://api.github.com/users/danielmewes/received_events","type":"User","site_admin":false},"created_at":"2016-02-05T21:09:15Z","updated_at":"2016-02-05T21:09:15Z","body":"@nodesocket Is this still an issue? Have you had a chance to run this with a different client? (as mentioned above, Data Explorer timings are not useful for benchmarking)."}}