{"action":"created","issue":{"url":"https://api.github.com/repos/edx/edx-platform/issues/8260","labels_url":"https://api.github.com/repos/edx/edx-platform/issues/8260/labels{/name}","comments_url":"https://api.github.com/repos/edx/edx-platform/issues/8260/comments","events_url":"https://api.github.com/repos/edx/edx-platform/issues/8260/events","html_url":"https://github.com/edx/edx-platform/pull/8260","id":82238657,"number":8260,"title":"Add CCX SQL query/Mongo read tests","user":{"login":"bdero","id":919017,"avatar_url":"https://avatars.githubusercontent.com/u/919017?v=3","gravatar_id":"","url":"https://api.github.com/users/bdero","html_url":"https://github.com/bdero","followers_url":"https://api.github.com/users/bdero/followers","following_url":"https://api.github.com/users/bdero/following{/other_user}","gists_url":"https://api.github.com/users/bdero/gists{/gist_id}","starred_url":"https://api.github.com/users/bdero/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bdero/subscriptions","organizations_url":"https://api.github.com/users/bdero/orgs","repos_url":"https://api.github.com/users/bdero/repos","events_url":"https://api.github.com/users/bdero/events{/privacy}","received_events_url":"https://api.github.com/users/bdero/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/edx/edx-platform/labels/open-source-contribution","name":"open-source-contribution","color":"bfe5bf"},{"url":"https://api.github.com/repos/edx/edx-platform/labels/waiting%20on%20author","name":"waiting on author","color":"0052cc"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":20,"created_at":"2015-05-29T03:36:14Z","updated_at":"2015-06-15T15:51:48Z","closed_at":"2015-06-15T15:51:48Z","pull_request":{"url":"https://api.github.com/repos/edx/edx-platform/pulls/8260","html_url":"https://github.com/edx/edx-platform/pull/8260","diff_url":"https://github.com/edx/edx-platform/pull/8260.diff","patch_url":"https://github.com/edx/edx-platform/pull/8260.patch"},"body":"This PR adds tests that instrument the amount of SQL queries and Mongo reads when grading in four states:\r\n\r\n- No field overrides; XML modulestore\r\n- CCX field override; XML modulestore\r\n- No field overrides; Split modulestore\r\n- CCX field override; Split modulestore\r\n\r\nFor each test, three slightly different courses are tested against: A course with 1 problem, a course with 2 problems, and a course with 3 problems respectively.\r\n\r\nThis provides a base for testing a solution to the field override performance issue as it's being developed. These tests should be passing currently, but once the problem with field overrides is addressed, they should be decreased to reflect the improved numbers.\r\n\r\nIf these end up being flaky, we should probably mark these tests as skipped as other flaky instrumenting tests already do.\r\n\r\nFYI @pdpinch, @cpennington."},"comment":{"url":"https://api.github.com/repos/edx/edx-platform/issues/comments/112117199","html_url":"https://github.com/edx/edx-platform/pull/8260#issuecomment-112117199","issue_url":"https://api.github.com/repos/edx/edx-platform/issues/8260","id":112117199,"user":{"login":"cpennington","id":30236,"avatar_url":"https://avatars.githubusercontent.com/u/30236?v=3","gravatar_id":"","url":"https://api.github.com/users/cpennington","html_url":"https://github.com/cpennington","followers_url":"https://api.github.com/users/cpennington/followers","following_url":"https://api.github.com/users/cpennington/following{/other_user}","gists_url":"https://api.github.com/users/cpennington/gists{/gist_id}","starred_url":"https://api.github.com/users/cpennington/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cpennington/subscriptions","organizations_url":"https://api.github.com/users/cpennington/orgs","repos_url":"https://api.github.com/users/cpennington/repos","events_url":"https://api.github.com/users/cpennington/events{/privacy}","received_events_url":"https://api.github.com/users/cpennington/received_events","type":"User","site_admin":false},"created_at":"2015-06-15T15:51:48Z","updated_at":"2015-06-15T15:51:48Z","body":"I just merged #8504, so I'm going to close this PR."}}