{"action":"created","issue":{"url":"https://api.github.com/repos/Gloirin/m2gTest/issues/5384","repository_url":"https://api.github.com/repos/Gloirin/m2gTest","labels_url":"https://api.github.com/repos/Gloirin/m2gTest/issues/5384/labels{/name}","comments_url":"https://api.github.com/repos/Gloirin/m2gTest/issues/5384/comments","events_url":"https://api.github.com/repos/Gloirin/m2gTest/issues/5384/events","html_url":"https://github.com/Gloirin/m2gTest/issues/5384","id":328053607,"node_id":"MDU6SXNzdWUzMjgwNTM2MDc=","number":5384,"title":"0009206:\nCalDAV Performance issues for many events","user":{"login":"Gloirin","id":24605609,"node_id":"MDQ6VXNlcjI0NjA1NjA5","avatar_url":"https://avatars1.githubusercontent.com/u/24605609?v=4","gravatar_id":"","url":"https://api.github.com/users/Gloirin","html_url":"https://github.com/Gloirin","followers_url":"https://api.github.com/users/Gloirin/followers","following_url":"https://api.github.com/users/Gloirin/following{/other_user}","gists_url":"https://api.github.com/users/Gloirin/gists{/gist_id}","starred_url":"https://api.github.com/users/Gloirin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gloirin/subscriptions","organizations_url":"https://api.github.com/users/Gloirin/orgs","repos_url":"https://api.github.com/users/Gloirin/repos","events_url":"https://api.github.com/users/Gloirin/events{/privacy}","received_events_url":"https://api.github.com/users/Gloirin/received_events","type":"User","site_admin":false},"labels":[{"id":948309336,"node_id":"MDU6TGFiZWw5NDgzMDkzMzY=","url":"https://api.github.com/repos/Gloirin/m2gTest/labels/CalDAV","name":"CalDAV","color":"ededed","default":false},{"id":948060620,"node_id":"MDU6TGFiZWw5NDgwNjA2MjA=","url":"https://api.github.com/repos/Gloirin/m2gTest/labels/bug","name":"bug","color":"d73a4a","default":true},{"id":948064871,"node_id":"MDU6TGFiZWw5NDgwNjQ4NzE=","url":"https://api.github.com/repos/Gloirin/m2gTest/labels/high%20priority","name":"high priority","color":"ededed","default":false}],"state":"closed","locked":false,"assignee":{"login":"Gloirin","id":24605609,"node_id":"MDQ6VXNlcjI0NjA1NjA5","avatar_url":"https://avatars1.githubusercontent.com/u/24605609?v=4","gravatar_id":"","url":"https://api.github.com/users/Gloirin","html_url":"https://github.com/Gloirin","followers_url":"https://api.github.com/users/Gloirin/followers","following_url":"https://api.github.com/users/Gloirin/following{/other_user}","gists_url":"https://api.github.com/users/Gloirin/gists{/gist_id}","starred_url":"https://api.github.com/users/Gloirin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gloirin/subscriptions","organizations_url":"https://api.github.com/users/Gloirin/orgs","repos_url":"https://api.github.com/users/Gloirin/repos","events_url":"https://api.github.com/users/Gloirin/events{/privacy}","received_events_url":"https://api.github.com/users/Gloirin/received_events","type":"User","site_admin":false},"assignees":[{"login":"Gloirin","id":24605609,"node_id":"MDQ6VXNlcjI0NjA1NjA5","avatar_url":"https://avatars1.githubusercontent.com/u/24605609?v=4","gravatar_id":"","url":"https://api.github.com/users/Gloirin","html_url":"https://github.com/Gloirin","followers_url":"https://api.github.com/users/Gloirin/followers","following_url":"https://api.github.com/users/Gloirin/following{/other_user}","gists_url":"https://api.github.com/users/Gloirin/gists{/gist_id}","starred_url":"https://api.github.com/users/Gloirin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gloirin/subscriptions","organizations_url":"https://api.github.com/users/Gloirin/orgs","repos_url":"https://api.github.com/users/Gloirin/repos","events_url":"https://api.github.com/users/Gloirin/events{/privacy}","received_events_url":"https://api.github.com/users/Gloirin/received_events","type":"User","site_admin":false}],"milestone":null,"comments":1,"created_at":"2018-05-31T09:04:39Z","updated_at":"2018-06-05T13:11:18Z","closed_at":"2018-05-31T09:04:39Z","author_association":"OWNER","body":"**Reported by ingoratsdorf on 5 Nov 2013 20:12**\n\n**Version:** git master\n\nI have duplicated my production database from Collin to GIT master.\r\nThe database contains some 8000 events from 4 users over the last 6 years.\r\nTested retrieving and updating events in both installations, Collin and GIT.\r\n\r\nResult:\r\nBoth KDE and MacOSX are okay in Collin, but EXTREMELY slow in GIT.\r\n\r\nUpdate event on OSX:\r\nCollin: 3 sec\r\nGIT: 55 sec\r\n\r\nRetrieving events on KDE:\r\nCollin: 20 sec\r\nGIT: don&#039;t know, impatient, stopped watching after a few minutes\r\n\r\nWHAT HAS CHANGED?\n\n**Steps to reproduce:** Set up two accounts, one for each Collin and GIT version.\r\nTest.\n\n**Additional information:** No additional information. No debug logs and the trace logs are FAAAAR to big to be posted here and there&#039;s SOOOOOOOOO much stuff in there that I cannot see anything.\r\n\r\nIf I have time, I will do some profiling by adding dedicated trace instructions.\r\nMy suspicion is that some logic in Tine20 GIT is iterating through each event comparing something in each event with each other event.\r\nThe more events, the exponentially longer the time it takes.\r\n\r\n10x10 = 100x\r\n100x100 = 10000x\r\n....\r\n\r\nAt some stage I had an array of more than 6000 events in an array before the time-range filter bug was addressed, now it&#039;s probably ONLY a few hundreds and the server is now at least not dying.... Just taking extremely long.\r\n\n"},"comment":{"url":"https://api.github.com/repos/Gloirin/m2gTest/issues/comments/394703148","html_url":"https://github.com/Gloirin/m2gTest/issues/5384#issuecomment-394703148","issue_url":"https://api.github.com/repos/Gloirin/m2gTest/issues/5384","id":394703148,"node_id":"MDEyOklzc3VlQ29tbWVudDM5NDcwMzE0OA==","user":{"login":"Gloirin","id":24605609,"node_id":"MDQ6VXNlcjI0NjA1NjA5","avatar_url":"https://avatars1.githubusercontent.com/u/24605609?v=4","gravatar_id":"","url":"https://api.github.com/users/Gloirin","html_url":"https://github.com/Gloirin","followers_url":"https://api.github.com/users/Gloirin/followers","following_url":"https://api.github.com/users/Gloirin/following{/other_user}","gists_url":"https://api.github.com/users/Gloirin/gists{/gist_id}","starred_url":"https://api.github.com/users/Gloirin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gloirin/subscriptions","organizations_url":"https://api.github.com/users/Gloirin/orgs","repos_url":"https://api.github.com/users/Gloirin/repos","events_url":"https://api.github.com/users/Gloirin/events{/privacy}","received_events_url":"https://api.github.com/users/Gloirin/received_events","type":"User","site_admin":false},"created_at":"2018-06-05T13:11:18Z","updated_at":"2018-06-05T13:11:18Z","author_association":"OWNER","body":"**Comment posted by cweiss on 15 Nov 2013 11:41**\n\nWithout having looked into the problem, i would expect that the grant calculation is guilty ;-)\r\n\r\nBefore Kristian Grants Calculation where done in SQL which caused a lot of load on the db servers. We decided to bring grants calculation into PHP as PHP servers are scaled more easily. \r\n\r\nBUT, it was moved to php in a hurry, and if i remember right, there was a lot of space for optimisations.\r\n\r\nxhopf/xdebug should unveil the problem very clearly ;-)"}}
{"actor":{"display_login":"Gloirin"}}