{"action":"created","issue":{"url":"https://api.github.com/repos/FrankMamuda/ketoevent/issues/10","repository_url":"https://api.github.com/repos/FrankMamuda/ketoevent","labels_url":"https://api.github.com/repos/FrankMamuda/ketoevent/issues/10/labels{/name}","comments_url":"https://api.github.com/repos/FrankMamuda/ketoevent/issues/10/comments","events_url":"https://api.github.com/repos/FrankMamuda/ketoevent/issues/10/events","html_url":"https://github.com/FrankMamuda/ketoevent/issues/10","id":115283098,"number":10,"title":"Performance issue on removing tasks","user":{"login":"FrankMamuda","id":1997097,"avatar_url":"https://avatars.githubusercontent.com/u/1997097?v=3","gravatar_id":"","url":"https://api.github.com/users/FrankMamuda","html_url":"https://github.com/FrankMamuda","followers_url":"https://api.github.com/users/FrankMamuda/followers","following_url":"https://api.github.com/users/FrankMamuda/following{/other_user}","gists_url":"https://api.github.com/users/FrankMamuda/gists{/gist_id}","starred_url":"https://api.github.com/users/FrankMamuda/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/FrankMamuda/subscriptions","organizations_url":"https://api.github.com/users/FrankMamuda/orgs","repos_url":"https://api.github.com/users/FrankMamuda/repos","events_url":"https://api.github.com/users/FrankMamuda/events{/privacy}","received_events_url":"https://api.github.com/users/FrankMamuda/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/FrankMamuda/ketoevent/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/FrankMamuda/ketoevent/milestones/2","html_url":"https://github.com/FrankMamuda/ketoevent/milestones/Post-event%20updates","labels_url":"https://api.github.com/repos/FrankMamuda/ketoevent/milestones/2/labels","id":1395579,"number":2,"title":"Post-event updates","description":"","creator":{"login":"FrankMamuda","id":1997097,"avatar_url":"https://avatars.githubusercontent.com/u/1997097?v=3","gravatar_id":"","url":"https://api.github.com/users/FrankMamuda","html_url":"https://github.com/FrankMamuda","followers_url":"https://api.github.com/users/FrankMamuda/followers","following_url":"https://api.github.com/users/FrankMamuda/following{/other_user}","gists_url":"https://api.github.com/users/FrankMamuda/gists{/gist_id}","starred_url":"https://api.github.com/users/FrankMamuda/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/FrankMamuda/subscriptions","organizations_url":"https://api.github.com/users/FrankMamuda/orgs","repos_url":"https://api.github.com/users/FrankMamuda/repos","events_url":"https://api.github.com/users/FrankMamuda/events{/privacy}","received_events_url":"https://api.github.com/users/FrankMamuda/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":5,"state":"open","created_at":"2015-11-05T13:25:55Z","updated_at":"2016-04-27T11:21:04Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2015-11-05T13:25:12Z","updated_at":"2016-04-28T07:55:23Z","closed_at":null,"body":"Reproduction:\r\n1) load a long list of tasks (~100);\r\n2) select a single task in the middle;\r\n3) delete it.\r\n\r\nIt takes a few seconds to complete.\r\n\r\nHow to fix:\r\na) use transactions (if applicable) - forums suggest this eliminates performance issues;\r\nb) use 'orphaning' - flag these tasks to be removed upon closing the app;\r\nc) use asynchronous deletion on a separate thread (move all sql operations to a separate thread?).\r\n"},"comment":{"url":"https://api.github.com/repos/FrankMamuda/ketoevent/issues/comments/215339886","html_url":"https://github.com/FrankMamuda/ketoevent/issues/10#issuecomment-215339886","issue_url":"https://api.github.com/repos/FrankMamuda/ketoevent/issues/10","id":215339886,"user":{"login":"FrankMamuda","id":1997097,"avatar_url":"https://avatars.githubusercontent.com/u/1997097?v=3","gravatar_id":"","url":"https://api.github.com/users/FrankMamuda","html_url":"https://github.com/FrankMamuda","followers_url":"https://api.github.com/users/FrankMamuda/followers","following_url":"https://api.github.com/users/FrankMamuda/following{/other_user}","gists_url":"https://api.github.com/users/FrankMamuda/gists{/gist_id}","starred_url":"https://api.github.com/users/FrankMamuda/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/FrankMamuda/subscriptions","organizations_url":"https://api.github.com/users/FrankMamuda/orgs","repos_url":"https://api.github.com/users/FrankMamuda/repos","events_url":"https://api.github.com/users/FrankMamuda/events{/privacy}","received_events_url":"https://api.github.com/users/FrankMamuda/received_events","type":"User","site_admin":false},"created_at":"2016-04-28T07:55:23Z","updated_at":"2016-04-28T07:55:23Z","body":"Another option would be to schedule re-indexing on shutdown."}}