{"action":"created","issue":{"url":"https://api.github.com/repos/silverstripe/silverstripe-blog/issues/311","labels_url":"https://api.github.com/repos/silverstripe/silverstripe-blog/issues/311/labels{/name}","comments_url":"https://api.github.com/repos/silverstripe/silverstripe-blog/issues/311/comments","events_url":"https://api.github.com/repos/silverstripe/silverstripe-blog/issues/311/events","html_url":"https://github.com/silverstripe/silverstripe-blog/issues/311","id":114005855,"number":311,"title":"BUG Sites with large number of users (Member) breaks","user":{"login":"camfindlay","id":367847,"avatar_url":"https://avatars.githubusercontent.com/u/367847?v=3","gravatar_id":"","url":"https://api.github.com/users/camfindlay","html_url":"https://github.com/camfindlay","followers_url":"https://api.github.com/users/camfindlay/followers","following_url":"https://api.github.com/users/camfindlay/following{/other_user}","gists_url":"https://api.github.com/users/camfindlay/gists{/gist_id}","starred_url":"https://api.github.com/users/camfindlay/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/camfindlay/subscriptions","organizations_url":"https://api.github.com/users/camfindlay/orgs","repos_url":"https://api.github.com/users/camfindlay/repos","events_url":"https://api.github.com/users/camfindlay/events{/privacy}","received_events_url":"https://api.github.com/users/camfindlay/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-10-29T08:58:49Z","updated_at":"2015-11-18T00:58:48Z","closed_at":"2015-11-18T00:58:47Z","body":"There are a number of fields that list Member to be selected to assign authors etc. These seem to all use Member::get() which given a sizable website with a large number of users brings everything to a grinding halt.\r\n\r\nThere should be some way to qualify a Member for select rather than a blanket \"get all the things\" for these situations.\r\n\r\nExample in BlogPost:\r\n```php\r\n$authorField = ListboxField::create(\r\n\t\t\t\t'Authors',\r\n\t\t\t\t_t('BlogPost.Authors', 'Authors'),\r\n\t\t\t\tMember::get()->map()->toArray()\r\n\t\t\t)->setMultiple(true);\r\n```\r\n\r\nThis kills my large site when I drill into a BlogPost, however if I add a simple ->limit(10) to the Member ORM call, no problem, page loads (though it's not useful in this state).\r\n\r\nI'd want to be able to set a config value denoting a Security group I can add any users to which becomes my pool of potential authors that are selectable. This keeps the whole thing more controllable and avoids issues with large user bases."},"comment":{"url":"https://api.github.com/repos/silverstripe/silverstripe-blog/issues/comments/157562265","html_url":"https://github.com/silverstripe/silverstripe-blog/issues/311#issuecomment-157562265","issue_url":"https://api.github.com/repos/silverstripe/silverstripe-blog/issues/311","id":157562265,"user":{"login":"camfindlay","id":367847,"avatar_url":"https://avatars.githubusercontent.com/u/367847?v=3","gravatar_id":"","url":"https://api.github.com/users/camfindlay","html_url":"https://github.com/camfindlay","followers_url":"https://api.github.com/users/camfindlay/followers","following_url":"https://api.github.com/users/camfindlay/following{/other_user}","gists_url":"https://api.github.com/users/camfindlay/gists{/gist_id}","starred_url":"https://api.github.com/users/camfindlay/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/camfindlay/subscriptions","organizations_url":"https://api.github.com/users/camfindlay/orgs","repos_url":"https://api.github.com/users/camfindlay/repos","events_url":"https://api.github.com/users/camfindlay/events{/privacy}","received_events_url":"https://api.github.com/users/camfindlay/received_events","type":"User","site_admin":false},"created_at":"2015-11-18T00:58:47Z","updated_at":"2015-11-18T00:58:47Z","body":"yip sure can! #312 fixes and we've tested on production in ss.org :+1: "}}