{"action":"opened","issue":{"url":"https://api.github.com/repos/HXLStandard/hxl-proxy/issues/55","labels_url":"https://api.github.com/repos/HXLStandard/hxl-proxy/issues/55/labels{/name}","comments_url":"https://api.github.com/repos/HXLStandard/hxl-proxy/issues/55/comments","events_url":"https://api.github.com/repos/HXLStandard/hxl-proxy/issues/55/events","html_url":"https://github.com/HXLStandard/hxl-proxy/issues/55","id":101899064,"number":55,"title":"Filtering very slow for 5,000+ row Google Sheet","user":{"login":"davidmegginson","id":2810060,"avatar_url":"https://avatars.githubusercontent.com/u/2810060?v=3","gravatar_id":"","url":"https://api.github.com/users/davidmegginson","html_url":"https://github.com/davidmegginson","followers_url":"https://api.github.com/users/davidmegginson/followers","following_url":"https://api.github.com/users/davidmegginson/following{/other_user}","gists_url":"https://api.github.com/users/davidmegginson/gists{/gist_id}","starred_url":"https://api.github.com/users/davidmegginson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davidmegginson/subscriptions","organizations_url":"https://api.github.com/users/davidmegginson/orgs","repos_url":"https://api.github.com/users/davidmegginson/repos","events_url":"https://api.github.com/users/davidmegginson/events{/privacy}","received_events_url":"https://api.github.com/users/davidmegginson/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/HXLStandard/hxl-proxy/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"davidmegginson","id":2810060,"avatar_url":"https://avatars.githubusercontent.com/u/2810060?v=3","gravatar_id":"","url":"https://api.github.com/users/davidmegginson","html_url":"https://github.com/davidmegginson","followers_url":"https://api.github.com/users/davidmegginson/followers","following_url":"https://api.github.com/users/davidmegginson/following{/other_user}","gists_url":"https://api.github.com/users/davidmegginson/gists{/gist_id}","starred_url":"https://api.github.com/users/davidmegginson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davidmegginson/subscriptions","organizations_url":"https://api.github.com/users/davidmegginson/orgs","repos_url":"https://api.github.com/users/davidmegginson/repos","events_url":"https://api.github.com/users/davidmegginson/events{/privacy}","received_events_url":"https://api.github.com/users/davidmegginson/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/HXLStandard/hxl-proxy/milestones/1","html_url":"https://github.com/HXLStandard/hxl-proxy/milestones/Soon","labels_url":"https://api.github.com/repos/HXLStandard/hxl-proxy/milestones/1/labels","id":977106,"number":1,"title":"Soon","description":"","creator":{"login":"davidmegginson","id":2810060,"avatar_url":"https://avatars.githubusercontent.com/u/2810060?v=3","gravatar_id":"","url":"https://api.github.com/users/davidmegginson","html_url":"https://github.com/davidmegginson","followers_url":"https://api.github.com/users/davidmegginson/followers","following_url":"https://api.github.com/users/davidmegginson/following{/other_user}","gists_url":"https://api.github.com/users/davidmegginson/gists{/gist_id}","starred_url":"https://api.github.com/users/davidmegginson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davidmegginson/subscriptions","organizations_url":"https://api.github.com/users/davidmegginson/orgs","repos_url":"https://api.github.com/users/davidmegginson/repos","events_url":"https://api.github.com/users/davidmegginson/events{/privacy}","received_events_url":"https://api.github.com/users/davidmegginson/received_events","type":"User","site_admin":false},"open_issues":7,"closed_issues":4,"state":"open","created_at":"2015-02-12T16:58:30Z","updated_at":"2015-08-19T13:52:54Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2015-08-19T13:52:54Z","updated_at":"2015-08-19T13:52:54Z","closed_at":null,"body":"@SimonbJohnson reports 16+-second response times for this, with the force parameter:\r\n\r\nhttp://beta.proxy.hxlstandard.org/data/edit?filter_count=7&url=https%3A//docs.google.com/spreadsheets/d/1Z4YWDKWnrSJPcyFEyHawRck0SrXg6R0hBriH7gBZuqA/pub%3Fgid%3D0%26single%3Dtrue%26output%3Dcsv&strip-headers=on&format=html&filter01=cut&cut-include-tags01=%23adm3%2Bcode%2C%23reached%2Bhouseholds%2C%23activity%2Bdescription&cut-exclude-tags01=&filter02=count&count-tags02=%23adm3%2Bcode%2C%23activity%2Bdescription&count-aggregate-tag02=%23reached%2Bhouseholds&filter03=&filter04=&filter05=&filter06=&filter07="}}