{"action":"created","issue":{"url":"https://api.github.com/repos/mantisbt/mantisbt/issues/654","labels_url":"https://api.github.com/repos/mantisbt/mantisbt/issues/654/labels{/name}","comments_url":"https://api.github.com/repos/mantisbt/mantisbt/issues/654/comments","events_url":"https://api.github.com/repos/mantisbt/mantisbt/issues/654/events","html_url":"https://github.com/mantisbt/mantisbt/pull/654","id":108417750,"number":654,"title":"use selective bug cache for attachment count","user":{"login":"cproensa","id":14123811,"avatar_url":"https://avatars.githubusercontent.com/u/14123811?v=3","gravatar_id":"","url":"https://api.github.com/users/cproensa","html_url":"https://github.com/cproensa","followers_url":"https://api.github.com/users/cproensa/followers","following_url":"https://api.github.com/users/cproensa/following{/other_user}","gists_url":"https://api.github.com/users/cproensa/gists{/gist_id}","starred_url":"https://api.github.com/users/cproensa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cproensa/subscriptions","organizations_url":"https://api.github.com/users/cproensa/orgs","repos_url":"https://api.github.com/users/cproensa/repos","events_url":"https://api.github.com/users/cproensa/events{/privacy}","received_events_url":"https://api.github.com/users/cproensa/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-09-25T22:28:23Z","updated_at":"2015-12-23T20:21:34Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/mantisbt/mantisbt/pulls/654","html_url":"https://github.com/mantisbt/mantisbt/pull/654","diff_url":"https://github.com/mantisbt/mantisbt/pull/654.diff","patch_url":"https://github.com/mantisbt/mantisbt/pull/654.patch"},"body":"use selective bug cache for attachment count instead of cache data for all bugs in db\r\nfetch data only for bugs included in filter result set\r\nfixes #0020138\r\n\r\nThe problem identified in bug #0020138, is that caching the attachment count query data for all bugs in database. This is unnecessary, and can penalize in db time, processing time and memory usage.\r\n\r\nModification uses the filter bug list and caches all of its values, only for that set. Usually all bugs accessed are those from the filter result, so subsequent calls to file_bug_attachment_count will hit the cache successfully. In other case, a single query will be issued.\r\n\r\nTypical scenario will perform one query in view_all_bug_page, and several queries in my_view_page (one for each filter box). Hopefully the queries and its processing are more lightweight that original approach.\r\n"},"comment":{"url":"https://api.github.com/repos/mantisbt/mantisbt/issues/comments/166983959","html_url":"https://github.com/mantisbt/mantisbt/pull/654#issuecomment-166983959","issue_url":"https://api.github.com/repos/mantisbt/mantisbt/issues/654","id":166983959,"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-12-23T20:21:34Z","updated_at":"2015-12-23T20:21:34Z","body":"@cproensa nice view of the callee map.  What tool did you use for that?"}}