{"action":"created","issue":{"url":"https://api.github.com/repos/praekelt/vumi-go/issues/1299","labels_url":"https://api.github.com/repos/praekelt/vumi-go/issues/1299/labels{/name}","comments_url":"https://api.github.com/repos/praekelt/vumi-go/issues/1299/comments","events_url":"https://api.github.com/repos/praekelt/vumi-go/issues/1299/events","html_url":"https://github.com/praekelt/vumi-go/pull/1299","id":90062073,"number":1299,"title":"Avoid performing many selects when archiving billing transactions","user":{"login":"hodgestar","id":165551,"avatar_url":"https://avatars.githubusercontent.com/u/165551?v=3","gravatar_id":"","url":"https://api.github.com/users/hodgestar","html_url":"https://github.com/hodgestar","followers_url":"https://api.github.com/users/hodgestar/followers","following_url":"https://api.github.com/users/hodgestar/following{/other_user}","gists_url":"https://api.github.com/users/hodgestar/gists{/gist_id}","starred_url":"https://api.github.com/users/hodgestar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hodgestar/subscriptions","organizations_url":"https://api.github.com/users/hodgestar/orgs","repos_url":"https://api.github.com/users/hodgestar/repos","events_url":"https://api.github.com/users/hodgestar/events{/privacy}","received_events_url":"https://api.github.com/users/hodgestar/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":8,"created_at":"2015-06-22T10:20:51Z","updated_at":"2015-06-24T06:51:17Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/praekelt/vumi-go/pulls/1299","html_url":"https://github.com/praekelt/vumi-go/pull/1299","diff_url":"https://github.com/praekelt/vumi-go/pull/1299.diff","patch_url":"https://github.com/praekelt/vumi-go/pull/1299.patch"},"body":"Our current implementation performs an ordered select query over all transactions for the month for every 1000 transactions which heavily loads the database and is very slow."},"comment":{"url":"https://api.github.com/repos/praekelt/vumi-go/issues/comments/114751333","html_url":"https://github.com/praekelt/vumi-go/pull/1299#issuecomment-114751333","issue_url":"https://api.github.com/repos/praekelt/vumi-go/issues/1299","id":114751333,"user":{"login":"rudigiesler","id":8234653,"avatar_url":"https://avatars.githubusercontent.com/u/8234653?v=3","gravatar_id":"","url":"https://api.github.com/users/rudigiesler","html_url":"https://github.com/rudigiesler","followers_url":"https://api.github.com/users/rudigiesler/followers","following_url":"https://api.github.com/users/rudigiesler/following{/other_user}","gists_url":"https://api.github.com/users/rudigiesler/gists{/gist_id}","starred_url":"https://api.github.com/users/rudigiesler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rudigiesler/subscriptions","organizations_url":"https://api.github.com/users/rudigiesler/orgs","repos_url":"https://api.github.com/users/rudigiesler/repos","events_url":"https://api.github.com/users/rudigiesler/events{/privacy}","received_events_url":"https://api.github.com/users/rudigiesler/received_events","type":"User","site_admin":false},"created_at":"2015-06-24T06:51:17Z","updated_at":"2015-06-24T06:51:17Z","body":" There's no real way that we can test memory usage during a test is there? We could use `resource`, but I'm not sure how reliable it would be."}}