{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/13725","labels_url":"https://api.github.com/repos/owncloud/core/issues/13725/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/13725/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/13725/events","html_url":"https://github.com/owncloud/core/issues/13725","id":55737777,"number":13725,"title":"Sharing to groups with many users becomes slower over time","user":{"login":"butonic","id":956847,"avatar_url":"https://avatars.githubusercontent.com/u/956847?v=3","gravatar_id":"","url":"https://api.github.com/users/butonic","html_url":"https://github.com/butonic","followers_url":"https://api.github.com/users/butonic/followers","following_url":"https://api.github.com/users/butonic/following{/other_user}","gists_url":"https://api.github.com/users/butonic/gists{/gist_id}","starred_url":"https://api.github.com/users/butonic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/butonic/subscriptions","organizations_url":"https://api.github.com/users/butonic/orgs","repos_url":"https://api.github.com/users/butonic/repos","events_url":"https://api.github.com/users/butonic/events{/privacy}","received_events_url":"https://api.github.com/users/butonic/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/owncloud/core/labels/green-ticket","name":"green-ticket","color":"00B85C"},{"url":"https://api.github.com/repos/owncloud/core/labels/Performance","name":"Performance","color":"fbca04"},{"url":"https://api.github.com/repos/owncloud/core/labels/Sharing","name":"Sharing","color":"e102d8"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-01-28T10:20:38Z","updated_at":"2015-01-28T12:06:00Z","closed_at":null,"body":"Sharing a file with a group not only creates one tupel in the oc_shares table for the group but also for every user in the group. That becomes a problem when sharing to large groups, as the number of rows in the table increases until we run into timeouts for huge groups.\r\n\r\nIMO the correct solution is yet again an mq system that takes decouples db changes from the web request.\r\n\r\ncc @schiesbn @DeepDiver1975 "},"comment":{"url":"https://api.github.com/repos/owncloud/core/issues/comments/71824986","html_url":"https://github.com/owncloud/core/issues/13725#issuecomment-71824986","issue_url":"https://api.github.com/repos/owncloud/core/issues/13725","id":71824986,"user":{"login":"PVince81","id":277525,"avatar_url":"https://avatars.githubusercontent.com/u/277525?v=3","gravatar_id":"","url":"https://api.github.com/users/PVince81","html_url":"https://github.com/PVince81","followers_url":"https://api.github.com/users/PVince81/followers","following_url":"https://api.github.com/users/PVince81/following{/other_user}","gists_url":"https://api.github.com/users/PVince81/gists{/gist_id}","starred_url":"https://api.github.com/users/PVince81/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PVince81/subscriptions","organizations_url":"https://api.github.com/users/PVince81/orgs","repos_url":"https://api.github.com/users/PVince81/repos","events_url":"https://api.github.com/users/PVince81/events{/privacy}","received_events_url":"https://api.github.com/users/PVince81/received_events","type":"User","site_admin":false},"created_at":"2015-01-28T12:06:00Z","updated_at":"2015-01-28T12:06:00Z","body":"Note: we cannot do without having those extra entries because users might rename the target folder.\r\n\r\nI agree with the background job approach, hopefully we can add this in the near future."}}