{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/13956","labels_url":"https://api.github.com/repos/owncloud/core/issues/13956/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/13956/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/13956/events","html_url":"https://github.com/owncloud/core/pull/13956","id":56859942,"number":13956,"title":"Move all child entries in the cache in a single query","user":{"login":"icewind1991","id":1283854,"avatar_url":"https://avatars.githubusercontent.com/u/1283854?v=3","gravatar_id":"","url":"https://api.github.com/users/icewind1991","html_url":"https://github.com/icewind1991","followers_url":"https://api.github.com/users/icewind1991/followers","following_url":"https://api.github.com/users/icewind1991/following{/other_user}","gists_url":"https://api.github.com/users/icewind1991/gists{/gist_id}","starred_url":"https://api.github.com/users/icewind1991/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/icewind1991/subscriptions","organizations_url":"https://api.github.com/users/icewind1991/orgs","repos_url":"https://api.github.com/users/icewind1991/repos","events_url":"https://api.github.com/users/icewind1991/events{/privacy}","received_events_url":"https://api.github.com/users/icewind1991/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/owncloud/core/labels/5%20-%20To%20review","name":"5 - To review","color":"ededed"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/owncloud/core/milestones/31","labels_url":"https://api.github.com/repos/owncloud/core/milestones/31/labels","id":912160,"number":31,"title":"8.1-next","description":"","creator":{"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},"open_issues":344,"closed_issues":23,"state":"open","created_at":"2014-12-22T12:04:01Z","updated_at":"2015-02-09T15:53:13Z","due_on":"2015-04-02T22:00:00Z","closed_at":null},"comments":3,"created_at":"2015-02-06T19:57:06Z","updated_at":"2015-02-09T16:01:43Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/owncloud/core/pulls/13956","html_url":"https://github.com/owncloud/core/pull/13956","diff_url":"https://github.com/owncloud/core/pull/13956.diff","patch_url":"https://github.com/owncloud/core/pull/13956.patch"},"body":"Use some sql magic to move the calculation of the updated fields to sql so we can do it all in a single query.\r\n\r\nMoves the time it takes to rename a folder with ~5k files down to ~180ms, [comparison](https://blackfire.io/profiles/compare/858dbbe2-3e19-45f5-8030-8b8cab579705/graph).\r\n\r\nAdds adds support for using `MD5()` in sql to oracle and mssql and using `CONCAT()` in sqlite.\r\n\r\ncc @DeepDiver1975 @PVince81 @MorrisJobke "},"comment":{"url":"https://api.github.com/repos/owncloud/core/issues/comments/73533927","html_url":"https://github.com/owncloud/core/pull/13956#issuecomment-73533927","issue_url":"https://api.github.com/repos/owncloud/core/issues/13956","id":73533927,"user":{"login":"nickvergessen","id":213943,"avatar_url":"https://avatars.githubusercontent.com/u/213943?v=3","gravatar_id":"","url":"https://api.github.com/users/nickvergessen","html_url":"https://github.com/nickvergessen","followers_url":"https://api.github.com/users/nickvergessen/followers","following_url":"https://api.github.com/users/nickvergessen/following{/other_user}","gists_url":"https://api.github.com/users/nickvergessen/gists{/gist_id}","starred_url":"https://api.github.com/users/nickvergessen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nickvergessen/subscriptions","organizations_url":"https://api.github.com/users/nickvergessen/orgs","repos_url":"https://api.github.com/users/nickvergessen/repos","events_url":"https://api.github.com/users/nickvergessen/events{/privacy}","received_events_url":"https://api.github.com/users/nickvergessen/received_events","type":"User","site_admin":false},"created_at":"2015-02-09T16:01:43Z","updated_at":"2015-02-09T16:01:43Z","body":"Please also add a test scenario with two folders:\r\n* `foobar` and \r\n* `foobar2`\r\n\r\nThen rename `foobar` and check whether `foobar2` is left untouched.\r\n\r\nI can't see it clearly in your code, if that works or not.\r\n"}}