{"action":"created","issue":{"url":"https://api.github.com/repos/mantisbt/mantisbt/issues/614","labels_url":"https://api.github.com/repos/mantisbt/mantisbt/issues/614/labels{/name}","comments_url":"https://api.github.com/repos/mantisbt/mantisbt/issues/614/comments","events_url":"https://api.github.com/repos/mantisbt/mantisbt/issues/614/events","html_url":"https://github.com/mantisbt/mantisbt/pull/614","id":93176184,"number":614,"title":"Optimize timeline features to minimize time and sql load","user":{"login":"vboctor","id":6446,"avatar_url":"https://avatars.githubusercontent.com/u/6446?v=3","gravatar_id":"","url":"https://api.github.com/users/vboctor","html_url":"https://github.com/vboctor","followers_url":"https://api.github.com/users/vboctor/followers","following_url":"https://api.github.com/users/vboctor/following{/other_user}","gists_url":"https://api.github.com/users/vboctor/gists{/gist_id}","starred_url":"https://api.github.com/users/vboctor/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vboctor/subscriptions","organizations_url":"https://api.github.com/users/vboctor/orgs","repos_url":"https://api.github.com/users/vboctor/repos","events_url":"https://api.github.com/users/vboctor/events{/privacy}","received_events_url":"https://api.github.com/users/vboctor/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-07-06T03:08:54Z","updated_at":"2015-07-06T13:27:08Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/mantisbt/mantisbt/pulls/614","html_url":"https://github.com/mantisbt/mantisbt/pull/614","diff_url":"https://github.com/mantisbt/mantisbt/pull/614.diff","patch_url":"https://github.com/mantisbt/mantisbt/pull/614.patch"},"body":"This change uses now works directly on bug history table rows and only processes the number of rows\r\nnecessary to render the number of rows required in the UI.  This significantly reduces the load in the\r\ndefault view which doesn't show all rows.  The big savings happen in busy weeks, with about parity for\r\nnormal weeks in terms of load.\r\n\r\n**Date Range based on mantisbt.org dataset**\r\n2014-12-05 .. 2014-12-12 [Prev] [Next]\r\n\r\n**After Optimization (collapsed)**\r\nTotal queries executed: 54\r\nUnique queries executed: 54\r\nTotal query execution time: 0.0746 seconds\r\n\r\n**Before Optimization (collapsed)**\r\nTotal queries executed: 515\r\nUnique queries executed: 515\r\nTotal query execution time: 0.2072 seconds\r\n\r\n**After Optimization (all)**\r\nTotal queries executed: 514\r\nUnique queries executed: 514\r\nTotal query execution time: 0.1747 seconds\r\n\r\n**Before Optimization (all)**\r\nTotal queries executed: 515\r\nUnique queries executed: 515\r\nTotal query execution time: 0.2086 seconds\r\n\r\nFixes [#18015](https://www.mantisbt.org/bugs/view.php?id=18015)"},"comment":{"url":"https://api.github.com/repos/mantisbt/mantisbt/issues/comments/118853550","html_url":"https://github.com/mantisbt/mantisbt/pull/614#issuecomment-118853550","issue_url":"https://api.github.com/repos/mantisbt/mantisbt/issues/614","id":118853550,"user":{"login":"vboctor","id":6446,"avatar_url":"https://avatars.githubusercontent.com/u/6446?v=3","gravatar_id":"","url":"https://api.github.com/users/vboctor","html_url":"https://github.com/vboctor","followers_url":"https://api.github.com/users/vboctor/followers","following_url":"https://api.github.com/users/vboctor/following{/other_user}","gists_url":"https://api.github.com/users/vboctor/gists{/gist_id}","starred_url":"https://api.github.com/users/vboctor/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vboctor/subscriptions","organizations_url":"https://api.github.com/users/vboctor/orgs","repos_url":"https://api.github.com/users/vboctor/repos","events_url":"https://api.github.com/users/vboctor/events{/privacy}","received_events_url":"https://api.github.com/users/vboctor/received_events","type":"User","site_admin":false},"created_at":"2015-07-06T13:27:08Z","updated_at":"2015-07-06T13:27:08Z","body":"@dregad I've done further refactoring that includes the cleanup work and guarantees accuracy in terms of number of events in the timeline and when to show the \"show more\" link.\r\n\r\n**After Optimization (default)**\r\nTotal queries executed: 151\r\nUnique queries executed: 151\r\nTotal query execution time: 0.0988 seconds\r\n\r\n**After optimization (all)**\r\nTotal queries executed: 565\r\nUnique queries executed: 565\r\nTotal query execution time: 0.1901 seconds\r\n\r\nI'm not sure of an easy way to go back and revise commits that are not on the top of the branch.  So unless you really care, I won't be revising text in these.\r\n\r\n@atrol Your comments are also addressed."}}