{"action":"created","issue":{"url":"https://api.github.com/repos/fernandooliveira/moodle-block_mentor/issues/28","repository_url":"https://api.github.com/repos/fernandooliveira/moodle-block_mentor","labels_url":"https://api.github.com/repos/fernandooliveira/moodle-block_mentor/issues/28/labels{/name}","comments_url":"https://api.github.com/repos/fernandooliveira/moodle-block_mentor/issues/28/comments","events_url":"https://api.github.com/repos/fernandooliveira/moodle-block_mentor/issues/28/events","html_url":"https://github.com/fernandooliveira/moodle-block_mentor/issues/28","id":188051635,"number":28,"title":"Queries not scaling?","user":{"login":"evandonovan","id":220685,"avatar_url":"https://avatars.githubusercontent.com/u/220685?v=3","gravatar_id":"","url":"https://api.github.com/users/evandonovan","html_url":"https://github.com/evandonovan","followers_url":"https://api.github.com/users/evandonovan/followers","following_url":"https://api.github.com/users/evandonovan/following{/other_user}","gists_url":"https://api.github.com/users/evandonovan/gists{/gist_id}","starred_url":"https://api.github.com/users/evandonovan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/evandonovan/subscriptions","organizations_url":"https://api.github.com/users/evandonovan/orgs","repos_url":"https://api.github.com/users/evandonovan/repos","events_url":"https://api.github.com/users/evandonovan/events{/privacy}","received_events_url":"https://api.github.com/users/evandonovan/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"fernandooliveira","id":842492,"avatar_url":"https://avatars.githubusercontent.com/u/842492?v=3","gravatar_id":"","url":"https://api.github.com/users/fernandooliveira","html_url":"https://github.com/fernandooliveira","followers_url":"https://api.github.com/users/fernandooliveira/followers","following_url":"https://api.github.com/users/fernandooliveira/following{/other_user}","gists_url":"https://api.github.com/users/fernandooliveira/gists{/gist_id}","starred_url":"https://api.github.com/users/fernandooliveira/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fernandooliveira/subscriptions","organizations_url":"https://api.github.com/users/fernandooliveira/orgs","repos_url":"https://api.github.com/users/fernandooliveira/repos","events_url":"https://api.github.com/users/fernandooliveira/events{/privacy}","received_events_url":"https://api.github.com/users/fernandooliveira/received_events","type":"User","site_admin":false},"assignees":[{"login":"fernandooliveira","id":842492,"avatar_url":"https://avatars.githubusercontent.com/u/842492?v=3","gravatar_id":"","url":"https://api.github.com/users/fernandooliveira","html_url":"https://github.com/fernandooliveira","followers_url":"https://api.github.com/users/fernandooliveira/followers","following_url":"https://api.github.com/users/fernandooliveira/following{/other_user}","gists_url":"https://api.github.com/users/fernandooliveira/gists{/gist_id}","starred_url":"https://api.github.com/users/fernandooliveira/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fernandooliveira/subscriptions","organizations_url":"https://api.github.com/users/fernandooliveira/orgs","repos_url":"https://api.github.com/users/fernandooliveira/repos","events_url":"https://api.github.com/users/fernandooliveira/events{/privacy}","received_events_url":"https://api.github.com/users/fernandooliveira/received_events","type":"User","site_admin":false},{"login":"mgardener","id":3392373,"avatar_url":"https://avatars.githubusercontent.com/u/3392373?v=3","gravatar_id":"","url":"https://api.github.com/users/mgardener","html_url":"https://github.com/mgardener","followers_url":"https://api.github.com/users/mgardener/followers","following_url":"https://api.github.com/users/mgardener/following{/other_user}","gists_url":"https://api.github.com/users/mgardener/gists{/gist_id}","starred_url":"https://api.github.com/users/mgardener/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mgardener/subscriptions","organizations_url":"https://api.github.com/users/mgardener/orgs","repos_url":"https://api.github.com/users/mgardener/repos","events_url":"https://api.github.com/users/mgardener/events{/privacy}","received_events_url":"https://api.github.com/users/mgardener/received_events","type":"User","site_admin":false}],"milestone":null,"comments":3,"created_at":"2016-11-08T17:18:15Z","updated_at":"2016-11-08T21:26:47Z","closed_at":"2016-11-08T21:26:46Z","body":"(Cross-post from the plugin page on Moodle.org in case this is a more appropriate bug report venue.)\r\n\r\nThis plugin was working great for us at first, but then we started to add more mentors/mentees. Now the Mentor Manager block's \"Show all mentors & mentees\" & \"Manage mentors\" pages take over 10 minutes or so to load, if they load at all - for the users that are privileged enough to see the full list. \r\n\r\nI am using Moodle 3.1.1+ and the 3.1.7 version of this plugin.\r\n\r\nI am on a CentOS 7 server running Apache 2.4.6, MariaDB 5.5.50 (a drop-in replacement for MySQL), and PHP 5.4.16. The server has ~12GB of memory, around half of which is currently free.\r\n\r\nIt seems to me that there must be something about the way that the queries are written that makes them not scale."},"comment":{"url":"https://api.github.com/repos/fernandooliveira/moodle-block_mentor/issues/comments/259264717","html_url":"https://github.com/fernandooliveira/moodle-block_mentor/issues/28#issuecomment-259264717","issue_url":"https://api.github.com/repos/fernandooliveira/moodle-block_mentor/issues/28","id":259264717,"user":{"login":"evandonovan","id":220685,"avatar_url":"https://avatars.githubusercontent.com/u/220685?v=3","gravatar_id":"","url":"https://api.github.com/users/evandonovan","html_url":"https://github.com/evandonovan","followers_url":"https://api.github.com/users/evandonovan/followers","following_url":"https://api.github.com/users/evandonovan/following{/other_user}","gists_url":"https://api.github.com/users/evandonovan/gists{/gist_id}","starred_url":"https://api.github.com/users/evandonovan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/evandonovan/subscriptions","organizations_url":"https://api.github.com/users/evandonovan/orgs","repos_url":"https://api.github.com/users/evandonovan/repos","events_url":"https://api.github.com/users/evandonovan/events{/privacy}","received_events_url":"https://api.github.com/users/evandonovan/received_events","type":"User","site_admin":false},"created_at":"2016-11-08T21:26:46Z","updated_at":"2016-11-08T21:26:46Z","body":"We've decided that we are going to upgrade to at least PHP 5.5. If I still have issues, I will reopen this, but until then, I'm closing this ticket."}}
{"actor":{"display_login":"evandonovan"}}