{"action":"created","issue":{"url":"https://api.github.com/repos/mozilla/kitsune/issues/3173","repository_url":"https://api.github.com/repos/mozilla/kitsune","labels_url":"https://api.github.com/repos/mozilla/kitsune/issues/3173/labels{/name}","comments_url":"https://api.github.com/repos/mozilla/kitsune/issues/3173/comments","events_url":"https://api.github.com/repos/mozilla/kitsune/issues/3173/events","html_url":"https://github.com/mozilla/kitsune/issues/3173","id":311177139,"number":3173,"title":"Improve performance of question_details view (mysql questions_question select)","user":{"login":"glogiotatidis","id":584352,"avatar_url":"https://avatars3.githubusercontent.com/u/584352?v=4","gravatar_id":"","url":"https://api.github.com/users/glogiotatidis","html_url":"https://github.com/glogiotatidis","followers_url":"https://api.github.com/users/glogiotatidis/followers","following_url":"https://api.github.com/users/glogiotatidis/following{/other_user}","gists_url":"https://api.github.com/users/glogiotatidis/gists{/gist_id}","starred_url":"https://api.github.com/users/glogiotatidis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/glogiotatidis/subscriptions","organizations_url":"https://api.github.com/users/glogiotatidis/orgs","repos_url":"https://api.github.com/users/glogiotatidis/repos","events_url":"https://api.github.com/users/glogiotatidis/events{/privacy}","received_events_url":"https://api.github.com/users/glogiotatidis/received_events","type":"User","site_admin":false},"labels":[{"id":898203068,"url":"https://api.github.com/repos/mozilla/kitsune/labels/Now","name":"Now","color":"ddea88","default":false},{"id":889799671,"url":"https://api.github.com/repos/mozilla/kitsune/labels/Performance","name":"Performance","color":"e011a2","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-04-04T10:43:22Z","updated_at":"2018-05-30T12:17:28Z","closed_at":null,"author_association":"MEMBER","body":"question_details view executes SQL queries that take a lot of time. Evaluate whether those queries can be removed, optimized and/or cached to improve performance.\r\n\r\nThis issue is related to the degraded performance SUMO experienced on Fri March 30th ([NR Error](https://rpm.newrelic.com/accounts/1299394/applications/45097089/downtime/34422892))\r\n\r\n - [question_details](https://rpm.newrelic.com/accounts/1299394/applications/45097089/transactions#id=5b225765625472616e73616374696f6e2f46756e6374696f6e2f6b697473756e652e7175657374696f6e732e76696577733a7175657374696f6e5f64657461696c73222c22225d) transaction\r\n - [questions_question](https://rpm.newrelic.com/accounts/1299394/applications/45097089/datastores#/overview/MySQL/drilldown?metric=Datastore%252Fstatement%252FMySQL%252Fquestions_question%252Fselect&value=total_call_time_per_minute) select transaction\r\n - [upload_imageattachment](https://rpm.newrelic.com/accounts/1299394/applications/45097089/datastores#/overview/MySQL/drilldown?metric=Datastore%2Fstatement%2FMySQL%2Fupload_imageattachment%2Fselect) select transaction "},"comment":{"url":"https://api.github.com/repos/mozilla/kitsune/issues/comments/393139693","html_url":"https://github.com/mozilla/kitsune/issues/3173#issuecomment-393139693","issue_url":"https://api.github.com/repos/mozilla/kitsune/issues/3173","id":393139693,"user":{"login":"glogiotatidis","id":584352,"avatar_url":"https://avatars3.githubusercontent.com/u/584352?v=4","gravatar_id":"","url":"https://api.github.com/users/glogiotatidis","html_url":"https://github.com/glogiotatidis","followers_url":"https://api.github.com/users/glogiotatidis/followers","following_url":"https://api.github.com/users/glogiotatidis/following{/other_user}","gists_url":"https://api.github.com/users/glogiotatidis/gists{/gist_id}","starred_url":"https://api.github.com/users/glogiotatidis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/glogiotatidis/subscriptions","organizations_url":"https://api.github.com/users/glogiotatidis/orgs","repos_url":"https://api.github.com/users/glogiotatidis/repos","events_url":"https://api.github.com/users/glogiotatidis/events{/privacy}","received_events_url":"https://api.github.com/users/glogiotatidis/received_events","type":"User","site_admin":false},"created_at":"2018-05-30T12:17:28Z","updated_at":"2018-05-30T12:17:28Z","author_association":"MEMBER","body":"We-re not done here yet, re-opening \r\n\r\nThis is live on https://dev.sumo.moz.works \r\n\r\n@safwanrahman can you please verify that this is working ok?"}}
{"actor":{"display_login":"glogiotatidis"}}