{"action":"closed","issue":{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/6134","repository_url":"https://api.github.com/repos/rethinkdb/rethinkdb","labels_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/6134/labels{/name}","comments_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/6134/comments","events_url":"https://api.github.com/repos/rethinkdb/rethinkdb/issues/6134/events","html_url":"https://github.com/rethinkdb/rethinkdb/issues/6134","id":181164071,"number":6134,"title":"GetNearest fast in development, slow in deployed cluster","user":{"login":"keighl","id":149019,"avatar_url":"https://avatars.githubusercontent.com/u/149019?v=3","gravatar_id":"","url":"https://api.github.com/users/keighl","html_url":"https://github.com/keighl","followers_url":"https://api.github.com/users/keighl/followers","following_url":"https://api.github.com/users/keighl/following{/other_user}","gists_url":"https://api.github.com/users/keighl/gists{/gist_id}","starred_url":"https://api.github.com/users/keighl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/keighl/subscriptions","organizations_url":"https://api.github.com/users/keighl/orgs","repos_url":"https://api.github.com/users/keighl/repos","events_url":"https://api.github.com/users/keighl/events{/privacy}","received_events_url":"https://api.github.com/users/keighl/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/labels/tp:performance","name":"tp:performance","color":"444444"}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/rethinkdb/rethinkdb/milestones/41","html_url":"https://github.com/rethinkdb/rethinkdb/milestones/subsequent","labels_url":"https://api.github.com/repos/rethinkdb/rethinkdb/milestones/41/labels","id":367201,"number":41,"title":"subsequent","description":"Issues in this milestone will be revisited after each major release during the planning stage for the major release after it. They will be moved to a specific release milestone if chosen for that release.","creator":{"login":"coffeemug","id":48436,"avatar_url":"https://avatars.githubusercontent.com/u/48436?v=3","gravatar_id":"","url":"https://api.github.com/users/coffeemug","html_url":"https://github.com/coffeemug","followers_url":"https://api.github.com/users/coffeemug/followers","following_url":"https://api.github.com/users/coffeemug/following{/other_user}","gists_url":"https://api.github.com/users/coffeemug/gists{/gist_id}","starred_url":"https://api.github.com/users/coffeemug/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coffeemug/subscriptions","organizations_url":"https://api.github.com/users/coffeemug/orgs","repos_url":"https://api.github.com/users/coffeemug/repos","events_url":"https://api.github.com/users/coffeemug/events{/privacy}","received_events_url":"https://api.github.com/users/coffeemug/received_events","type":"User","site_admin":false},"open_issues":270,"closed_issues":1,"state":"open","created_at":"2013-06-30T07:32:52Z","updated_at":"2016-10-17T17:08:03Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2016-10-05T14:07:17Z","updated_at":"2016-10-17T17:08:03Z","closed_at":"2016-10-17T17:08:03Z","body":"Hey team rethink. I'm having a peculiar issue where a `getNearest()` runs nice and fast on my local machine (~50ms), but very slow on a deployed cluster (~800ms). \r\n\r\nIt's the same exact data. About 100 documents (each with a handful of nested data). A geo index on `coordinates`.\r\n\r\n**Local machine**\r\nServers: 1\r\nVersion: 2.3.5\r\nCache: 1.1GB\r\nClient connects directly\r\n\r\n**Deployed cluster**\r\nServers: 3\r\nVersion: 2.3.5~0jessie\r\nCache(each): 1GB\r\nTable replicas on all 3 nodes\r\nClients connect through a rethink proxy\r\nDeployed via kubernetes\r\n\r\n**Query:**\r\n\r\n```js\r\nr.db(\"xxx\").table(\"places\").getNearest(r.point(-73.97438, 40.7691017), {\r\n\tindex: \"coordinates\",\r\n\tmaxDist: 14,\r\n\tunit: \"km\",\r\n})\r\n```\r\n\r\nAny insight as to what the difference in performance might be? Happy to give more information. \r\n\r\nThank you all!\r\n\r\n"}}
{"actor":{"display_login":"keighl"}}