{"action":"created","issue":{"url":"https://api.github.com/repos/OpenHumans/open-humans/issues/853","repository_url":"https://api.github.com/repos/OpenHumans/open-humans","labels_url":"https://api.github.com/repos/OpenHumans/open-humans/issues/853/labels{/name}","comments_url":"https://api.github.com/repos/OpenHumans/open-humans/issues/853/comments","events_url":"https://api.github.com/repos/OpenHumans/open-humans/issues/853/events","html_url":"https://github.com/OpenHumans/open-humans/issues/853","id":359122911,"node_id":"MDU6SXNzdWUzNTkxMjI5MTE=","number":853,"title":"Site times out for /members list","user":{"login":"madprime","id":82631,"node_id":"MDQ6VXNlcjgyNjMx","avatar_url":"https://avatars3.githubusercontent.com/u/82631?v=4","gravatar_id":"","url":"https://api.github.com/users/madprime","html_url":"https://github.com/madprime","followers_url":"https://api.github.com/users/madprime/followers","following_url":"https://api.github.com/users/madprime/following{/other_user}","gists_url":"https://api.github.com/users/madprime/gists{/gist_id}","starred_url":"https://api.github.com/users/madprime/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/madprime/subscriptions","organizations_url":"https://api.github.com/users/madprime/orgs","repos_url":"https://api.github.com/users/madprime/repos","events_url":"https://api.github.com/users/madprime/events{/privacy}","received_events_url":"https://api.github.com/users/madprime/received_events","type":"User","site_admin":false},"labels":[{"id":114531812,"node_id":"MDU6TGFiZWwxMTQ1MzE4MTI=","url":"https://api.github.com/repos/OpenHumans/open-humans/labels/bug","name":"bug","color":"fc2929","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-09-11T16:23:43Z","updated_at":"2018-09-11T18:54:11Z","closed_at":null,"author_association":"MEMBER","body":"The update for badges (#846) seems to have introduced an inefficiency that's causing all member list pages to time out. This may be causing site-wide timeouts as servers get clogged on these requests.\r\n\r\n1. Remove URL path for the list for now (it won't work anyway)\r\n2. Fix the code so this works"},"comment":{"url":"https://api.github.com/repos/OpenHumans/open-humans/issues/comments/420382584","html_url":"https://github.com/OpenHumans/open-humans/issues/853#issuecomment-420382584","issue_url":"https://api.github.com/repos/OpenHumans/open-humans/issues/853","id":420382584,"node_id":"MDEyOklzc3VlQ29tbWVudDQyMDM4MjU4NA==","user":{"login":"jhdulaney","id":952067,"node_id":"MDQ6VXNlcjk1MjA2Nw==","avatar_url":"https://avatars2.githubusercontent.com/u/952067?v=4","gravatar_id":"","url":"https://api.github.com/users/jhdulaney","html_url":"https://github.com/jhdulaney","followers_url":"https://api.github.com/users/jhdulaney/followers","following_url":"https://api.github.com/users/jhdulaney/following{/other_user}","gists_url":"https://api.github.com/users/jhdulaney/gists{/gist_id}","starred_url":"https://api.github.com/users/jhdulaney/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jhdulaney/subscriptions","organizations_url":"https://api.github.com/users/jhdulaney/orgs","repos_url":"https://api.github.com/users/jhdulaney/repos","events_url":"https://api.github.com/users/jhdulaney/events{/privacy}","received_events_url":"https://api.github.com/users/jhdulaney/received_events","type":"User","site_admin":false},"created_at":"2018-09-11T18:54:10Z","updated_at":"2018-09-11T18:54:10Z","author_association":"CONTRIBUTOR","body":"Noting that the reason for this is that we are sorting the members list within Python, which causes the queryset to resolve.  The true solution will require doing the sort within the database.  This should be possible by annotating each member with a badge count that can be done entirely within the queryset."}}
{"actor":{"display_login":"jhdulaney"}}