{"action":"created","issue":{"url":"https://api.github.com/repos/GFDRR/thinkhazard/issues/62","labels_url":"https://api.github.com/repos/GFDRR/thinkhazard/issues/62/labels{/name}","comments_url":"https://api.github.com/repos/GFDRR/thinkhazard/issues/62/comments","events_url":"https://api.github.com/repos/GFDRR/thinkhazard/issues/62/events","html_url":"https://github.com/GFDRR/thinkhazard/issues/62","id":73891769,"number":62,"title":"Searching \"administrative divisions\" has gotten too slow","user":{"login":"elemoine","id":76594,"avatar_url":"https://avatars.githubusercontent.com/u/76594?v=3","gravatar_id":"","url":"https://api.github.com/users/elemoine","html_url":"https://github.com/elemoine","followers_url":"https://api.github.com/users/elemoine/followers","following_url":"https://api.github.com/users/elemoine/following{/other_user}","gists_url":"https://api.github.com/users/elemoine/gists{/gist_id}","starred_url":"https://api.github.com/users/elemoine/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elemoine/subscriptions","organizations_url":"https://api.github.com/users/elemoine/orgs","repos_url":"https://api.github.com/users/elemoine/repos","events_url":"https://api.github.com/users/elemoine/events{/privacy}","received_events_url":"https://api.github.com/users/elemoine/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/GFDRR/thinkhazard/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"elemoine","id":76594,"avatar_url":"https://avatars.githubusercontent.com/u/76594?v=3","gravatar_id":"","url":"https://api.github.com/users/elemoine","html_url":"https://github.com/elemoine","followers_url":"https://api.github.com/users/elemoine/followers","following_url":"https://api.github.com/users/elemoine/following{/other_user}","gists_url":"https://api.github.com/users/elemoine/gists{/gist_id}","starred_url":"https://api.github.com/users/elemoine/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/elemoine/subscriptions","organizations_url":"https://api.github.com/users/elemoine/orgs","repos_url":"https://api.github.com/users/elemoine/repos","events_url":"https://api.github.com/users/elemoine/events{/privacy}","received_events_url":"https://api.github.com/users/elemoine/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/GFDRR/thinkhazard/milestones/3","html_url":"https://github.com/GFDRR/thinkhazard/milestones/1.0%20RC","labels_url":"https://api.github.com/repos/GFDRR/thinkhazard/milestones/3/labels","id":1121833,"number":3,"title":"1.0 RC","description":"Expected end of March 2016, handles all hazard types + load.","creator":{"login":"fvanderbiest","id":265319,"avatar_url":"https://avatars.githubusercontent.com/u/265319?v=3","gravatar_id":"","url":"https://api.github.com/users/fvanderbiest","html_url":"https://github.com/fvanderbiest","followers_url":"https://api.github.com/users/fvanderbiest/followers","following_url":"https://api.github.com/users/fvanderbiest/following{/other_user}","gists_url":"https://api.github.com/users/fvanderbiest/gists{/gist_id}","starred_url":"https://api.github.com/users/fvanderbiest/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fvanderbiest/subscriptions","organizations_url":"https://api.github.com/users/fvanderbiest/orgs","repos_url":"https://api.github.com/users/fvanderbiest/repos","events_url":"https://api.github.com/users/fvanderbiest/events{/privacy}","received_events_url":"https://api.github.com/users/fvanderbiest/received_events","type":"User","site_admin":false},"open_issues":4,"closed_issues":1,"state":"open","created_at":"2015-05-20T19:04:17Z","updated_at":"2015-06-18T13:17:23Z","due_on":"2016-03-31T04:00:00Z","closed_at":null},"comments":1,"created_at":"2015-05-07T08:16:57Z","updated_at":"2015-09-29T14:05:11Z","closed_at":null,"body":"We need to find a way to optimize the search. It's gotten too slow since the switch to the new database model (where all the admin divisions are in the same table)."},"comment":{"url":"https://api.github.com/repos/GFDRR/thinkhazard/issues/comments/144071031","html_url":"https://github.com/GFDRR/thinkhazard/issues/62#issuecomment-144071031","issue_url":"https://api.github.com/repos/GFDRR/thinkhazard/issues/62","id":144071031,"user":{"login":"stufraser1","id":12515042,"avatar_url":"https://avatars.githubusercontent.com/u/12515042?v=3","gravatar_id":"","url":"https://api.github.com/users/stufraser1","html_url":"https://github.com/stufraser1","followers_url":"https://api.github.com/users/stufraser1/followers","following_url":"https://api.github.com/users/stufraser1/following{/other_user}","gists_url":"https://api.github.com/users/stufraser1/gists{/gist_id}","starred_url":"https://api.github.com/users/stufraser1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/stufraser1/subscriptions","organizations_url":"https://api.github.com/users/stufraser1/orgs","repos_url":"https://api.github.com/users/stufraser1/repos","events_url":"https://api.github.com/users/stufraser1/events{/privacy}","received_events_url":"https://api.github.com/users/stufraser1/received_events","type":"User","site_admin":false},"created_at":"2015-09-29T14:05:11Z","updated_at":"2015-09-29T14:05:11Z","body":"Related to this: \r\nWhen users type a location name into the search bar and try to press enter, it doesn't work immediately;  they must wait for the dropdown list to appear before they can press enter and have it work successfully.\r\nIf the search of admin divisions cannot be sped up, can we allow users to press enter without having to wait for the dropdown list to appear?"}}