{"action":"created","issue":{"url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/issues/765","repository_url":"https://api.github.com/repos/FreeUKGen/MyopicVicar","labels_url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/issues/765/labels{/name}","comments_url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/issues/765/comments","events_url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/issues/765/events","html_url":"https://github.com/FreeUKGen/MyopicVicar/issues/765","id":145521837,"number":765,"title":"Long running search","user":{"login":"Captainkirkdawson","id":2874694,"avatar_url":"https://avatars.githubusercontent.com/u/2874694?v=3","gravatar_id":"","url":"https://api.github.com/users/Captainkirkdawson","html_url":"https://github.com/Captainkirkdawson","followers_url":"https://api.github.com/users/Captainkirkdawson/followers","following_url":"https://api.github.com/users/Captainkirkdawson/following{/other_user}","gists_url":"https://api.github.com/users/Captainkirkdawson/gists{/gist_id}","starred_url":"https://api.github.com/users/Captainkirkdawson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Captainkirkdawson/subscriptions","organizations_url":"https://api.github.com/users/Captainkirkdawson/orgs","repos_url":"https://api.github.com/users/Captainkirkdawson/repos","events_url":"https://api.github.com/users/Captainkirkdawson/events{/privacy}","received_events_url":"https://api.github.com/users/Captainkirkdawson/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/labels/testing","name":"testing","color":"ededed"}],"state":"open","locked":false,"assignee":{"login":"Captainkirkdawson","id":2874694,"avatar_url":"https://avatars.githubusercontent.com/u/2874694?v=3","gravatar_id":"","url":"https://api.github.com/users/Captainkirkdawson","html_url":"https://github.com/Captainkirkdawson","followers_url":"https://api.github.com/users/Captainkirkdawson/followers","following_url":"https://api.github.com/users/Captainkirkdawson/following{/other_user}","gists_url":"https://api.github.com/users/Captainkirkdawson/gists{/gist_id}","starred_url":"https://api.github.com/users/Captainkirkdawson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Captainkirkdawson/subscriptions","organizations_url":"https://api.github.com/users/Captainkirkdawson/orgs","repos_url":"https://api.github.com/users/Captainkirkdawson/repos","events_url":"https://api.github.com/users/Captainkirkdawson/events{/privacy}","received_events_url":"https://api.github.com/users/Captainkirkdawson/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2016-04-03T17:34:23Z","updated_at":"2016-05-30T16:38:42Z","closed_at":null,"body":"Long running search; not the different formatting of the 2 dates\n\n2016-04-03T15:31:24.494+0100 [conn1132131] query myopic_vicar_production_20150223.search_records query: { $query: { chapman_code: { $in: [ \"NFK\" ] }, search_dates: { $elemMatch: { $gt: \"1933\", $lt: \"1971-01-01\" } }, search_names: { $elemMatch: { type: \"p\", first_name: \"ann\", last_name: \"reeve\" } } }, $hint: \"county_fn_ln_sd\" } planSummary: IXSCAN { chapman_code: 1, search_names.first_name: 1, search_names.last_name: 1, search_date: 1 } ntoreturn:250 ntoskip:0 nscanned:1303 nscannedObjects:1303 keyUpdates:0 numYields:841 locks(micros) r:2138678 nreturned:2 reslen:2313 29873ms"},"comment":{"url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/issues/comments/222525646","html_url":"https://github.com/FreeUKGen/MyopicVicar/issues/765#issuecomment-222525646","issue_url":"https://api.github.com/repos/FreeUKGen/MyopicVicar/issues/765","id":222525646,"user":{"login":"Captainkirkdawson","id":2874694,"avatar_url":"https://avatars.githubusercontent.com/u/2874694?v=3","gravatar_id":"","url":"https://api.github.com/users/Captainkirkdawson","html_url":"https://github.com/Captainkirkdawson","followers_url":"https://api.github.com/users/Captainkirkdawson/followers","following_url":"https://api.github.com/users/Captainkirkdawson/following{/other_user}","gists_url":"https://api.github.com/users/Captainkirkdawson/gists{/gist_id}","starred_url":"https://api.github.com/users/Captainkirkdawson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Captainkirkdawson/subscriptions","organizations_url":"https://api.github.com/users/Captainkirkdawson/orgs","repos_url":"https://api.github.com/users/Captainkirkdawson/repos","events_url":"https://api.github.com/users/Captainkirkdawson/events{/privacy}","received_events_url":"https://api.github.com/users/Captainkirkdawson/received_events","type":"User","site_admin":false},"created_at":"2016-05-30T16:38:42Z","updated_at":"2016-05-30T16:38:42Z","body":"I believe there to be an issue with the use of gte or lte in string searches that bypasses the indexes"}}
{"actor":{"display_login":"Captainkirkdawson"}}