{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/7474","labels_url":"https://api.github.com/repos/owncloud/core/issues/7474/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/7474/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/7474/events","html_url":"https://github.com/owncloud/core/issues/7474","id":28496117,"number":7474,"title":"Missing indexes to speed up large installations","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/db:mssql","name":"db:mssql","color":"444444"},{"url":"https://api.github.com/repos/owncloud/core/labels/db:mysql","name":"db:mysql","color":"444444"},{"url":"https://api.github.com/repos/owncloud/core/labels/db:oracle","name":"db:oracle","color":"444444"},{"url":"https://api.github.com/repos/owncloud/core/labels/db:postgresql","name":"db:postgresql","color":"444444"},{"url":"https://api.github.com/repos/owncloud/core/labels/db:sqlite","name":"db:sqlite","color":"444444"},{"url":"https://api.github.com/repos/owncloud/core/labels/enhancement","name":"enhancement","color":"02e10c"},{"url":"https://api.github.com/repos/owncloud/core/labels/performance","name":"performance","color":"fbca04"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/owncloud/core/milestones/37","html_url":"https://github.com/owncloud/core/milestones/8.2-current","labels_url":"https://api.github.com/repos/owncloud/core/milestones/37/labels","id":993629,"number":37,"title":"8.2-current","description":"","creator":{"login":"craigpg","id":160667,"avatar_url":"https://avatars.githubusercontent.com/u/160667?v=3","gravatar_id":"","url":"https://api.github.com/users/craigpg","html_url":"https://github.com/craigpg","followers_url":"https://api.github.com/users/craigpg/followers","following_url":"https://api.github.com/users/craigpg/following{/other_user}","gists_url":"https://api.github.com/users/craigpg/gists{/gist_id}","starred_url":"https://api.github.com/users/craigpg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/craigpg/subscriptions","organizations_url":"https://api.github.com/users/craigpg/orgs","repos_url":"https://api.github.com/users/craigpg/repos","events_url":"https://api.github.com/users/craigpg/events{/privacy}","received_events_url":"https://api.github.com/users/craigpg/received_events","type":"User","site_admin":false},"open_issues":615,"closed_issues":85,"state":"open","created_at":"2015-02-24T16:19:37Z","updated_at":"2015-07-08T15:14:38Z","due_on":"2015-10-14T22:00:00Z","closed_at":null},"comments":14,"created_at":"2014-02-28T12:08:28Z","updated_at":"2015-07-08T15:59:49Z","closed_at":null,"body":"Moving this here so we don't forget them:\r\n```sql\r\n   create index oc_group_user_uid on oc_group_user(uid);\r\n   create index oc_share_file_target on oc_share(file_target);\r\n   create index oc_filepath on oc_filecache(storage,size);\r\n   create index oc_files_versions_user on oc_files_versions(user);\r\n   create index oc_files_trashsize_user on oc_files_trashsize(user);\r\n```\r\n\r\nWould be awesome if someone chould verify that they are actually helpful."},"comment":{"url":"https://api.github.com/repos/owncloud/core/issues/comments/119635196","html_url":"https://github.com/owncloud/core/issues/7474#issuecomment-119635196","issue_url":"https://api.github.com/repos/owncloud/core/issues/7474","id":119635196,"user":{"login":"MorrisJobke","id":245432,"avatar_url":"https://avatars.githubusercontent.com/u/245432?v=3","gravatar_id":"","url":"https://api.github.com/users/MorrisJobke","html_url":"https://github.com/MorrisJobke","followers_url":"https://api.github.com/users/MorrisJobke/followers","following_url":"https://api.github.com/users/MorrisJobke/following{/other_user}","gists_url":"https://api.github.com/users/MorrisJobke/gists{/gist_id}","starred_url":"https://api.github.com/users/MorrisJobke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MorrisJobke/subscriptions","organizations_url":"https://api.github.com/users/MorrisJobke/orgs","repos_url":"https://api.github.com/users/MorrisJobke/repos","events_url":"https://api.github.com/users/MorrisJobke/events{/privacy}","received_events_url":"https://api.github.com/users/MorrisJobke/received_events","type":"User","site_admin":false},"created_at":"2015-07-08T15:59:49Z","updated_at":"2015-07-08T15:59:49Z","body":"> create index oc_files_versions_user on oc_files_versions(user);\r\n\r\n7ad0fee0b56d9ab678cbb52128d427ebd641b05e"}}