{"action":"created","issue":{"url":"https://api.github.com/repos/arangodb/arangodb/issues/1536","labels_url":"https://api.github.com/repos/arangodb/arangodb/issues/1536/labels{/name}","comments_url":"https://api.github.com/repos/arangodb/arangodb/issues/1536/comments","events_url":"https://api.github.com/repos/arangodb/arangodb/issues/1536/events","html_url":"https://github.com/arangodb/arangodb/issues/1536","id":112778167,"number":1536,"title":"Geo-location performance ","user":{"login":"andreib1","id":2752520,"avatar_url":"https://avatars.githubusercontent.com/u/2752520?v=3","gravatar_id":"","url":"https://api.github.com/users/andreib1","html_url":"https://github.com/andreib1","followers_url":"https://api.github.com/users/andreib1/followers","following_url":"https://api.github.com/users/andreib1/following{/other_user}","gists_url":"https://api.github.com/users/andreib1/gists{/gist_id}","starred_url":"https://api.github.com/users/andreib1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andreib1/subscriptions","organizations_url":"https://api.github.com/users/andreib1/orgs","repos_url":"https://api.github.com/users/andreib1/repos","events_url":"https://api.github.com/users/andreib1/events{/privacy}","received_events_url":"https://api.github.com/users/andreib1/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/arangodb/arangodb/labels/3_Feature","name":"3_Feature","color":"02e10c"},{"url":"https://api.github.com/repos/arangodb/arangodb/labels/aql","name":"aql","color":"444444"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2015-10-22T10:55:57Z","updated_at":"2015-10-23T15:34:43Z","closed_at":null,"body":"I have found there are issues with Geo-location when it comes to applying additional filters.  Geo-location does not seem to utilize its index with the rest of the query.\r\n\r\nYou can see this for yourself if you load test data:\r\n\r\ndb._useDatabase(\"_system\");\r\ndb._createDatabase(\"WithinTest\");\r\ndb._useDatabase(\"WithinTest\");\r\ndb._create(\"LatLongs\");\r\nfor (var i = 0; i < 30000; i++) { db.LatLongs.save({lat: 0, long: 0, number:\r\ni }); }\r\ndb.LatLongs.ensureGeoIndex(\"lat\", \"long\");\r\n\r\nAnd run the following query:\r\n\r\nFOR x IN WITHIN(LatLongs, 0, 0, 0)\r\nLIMIT 1\r\nRETURN x._key\r\n\r\nOn my machine .75 to 1 second to execute for a single result, which implies that it is not streaming results from its index, and that it is enumerating all results before proceeding the query."},"comment":{"url":"https://api.github.com/repos/arangodb/arangodb/issues/comments/150609814","html_url":"https://github.com/arangodb/arangodb/issues/1536#issuecomment-150609814","issue_url":"https://api.github.com/repos/arangodb/arangodb/issues/1536","id":150609814,"user":{"login":"dothebart","id":5013077,"avatar_url":"https://avatars.githubusercontent.com/u/5013077?v=3","gravatar_id":"","url":"https://api.github.com/users/dothebart","html_url":"https://github.com/dothebart","followers_url":"https://api.github.com/users/dothebart/followers","following_url":"https://api.github.com/users/dothebart/following{/other_user}","gists_url":"https://api.github.com/users/dothebart/gists{/gist_id}","starred_url":"https://api.github.com/users/dothebart/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dothebart/subscriptions","organizations_url":"https://api.github.com/users/dothebart/orgs","repos_url":"https://api.github.com/users/dothebart/repos","events_url":"https://api.github.com/users/dothebart/events{/privacy}","received_events_url":"https://api.github.com/users/dothebart/received_events","type":"User","site_admin":false},"created_at":"2015-10-23T15:34:43Z","updated_at":"2015-10-23T15:34:43Z","body":"yes, you only can use joins afterwards to combine the results."}}