{"action":"created","issue":{"url":"https://api.github.com/repos/eventespresso/event-espresso-core/issues/708","repository_url":"https://api.github.com/repos/eventespresso/event-espresso-core","labels_url":"https://api.github.com/repos/eventespresso/event-espresso-core/issues/708/labels{/name}","comments_url":"https://api.github.com/repos/eventespresso/event-espresso-core/issues/708/comments","events_url":"https://api.github.com/repos/eventespresso/event-espresso-core/issues/708/events","html_url":"https://github.com/eventespresso/event-espresso-core/pull/708","id":363376023,"node_id":"MDExOlB1bGxSZXF1ZXN0MjE3ODMxMDMy","number":708,"title":"Fix memory timeout for sites with a brazillion tags","user":{"login":"tn3rb","id":1751030,"node_id":"MDQ6VXNlcjE3NTEwMzA=","avatar_url":"https://avatars1.githubusercontent.com/u/1751030?v=4","gravatar_id":"","url":"https://api.github.com/users/tn3rb","html_url":"https://github.com/tn3rb","followers_url":"https://api.github.com/users/tn3rb/followers","following_url":"https://api.github.com/users/tn3rb/following{/other_user}","gists_url":"https://api.github.com/users/tn3rb/gists{/gist_id}","starred_url":"https://api.github.com/users/tn3rb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tn3rb/subscriptions","organizations_url":"https://api.github.com/users/tn3rb/orgs","repos_url":"https://api.github.com/users/tn3rb/repos","events_url":"https://api.github.com/users/tn3rb/events{/privacy}","received_events_url":"https://api.github.com/users/tn3rb/received_events","type":"User","site_admin":false},"labels":[{"id":904083535,"node_id":"MDU6TGFiZWw5MDQwODM1MzU=","url":"https://api.github.com/repos/eventespresso/event-espresso-core/labels/category:frontend-ui-&-ux","name":"category:frontend-ui-&-ux","color":"abc2c1","default":false},{"id":904083603,"node_id":"MDU6TGFiZWw5MDQwODM2MDM=","url":"https://api.github.com/repos/eventespresso/event-espresso-core/labels/category:models-and-data-infrastructure","name":"category:models-and-data-infrastructure","color":"abc2c1","default":false},{"id":906261986,"node_id":"MDU6TGFiZWw5MDYyNjE5ODY=","url":"https://api.github.com/repos/eventespresso/event-espresso-core/labels/status:needs-testing","name":"status:needs-testing","color":"eb4f21","default":false}],"state":"open","locked":false,"assignee":{"login":"sethshoultes","id":235315,"node_id":"MDQ6VXNlcjIzNTMxNQ==","avatar_url":"https://avatars3.githubusercontent.com/u/235315?v=4","gravatar_id":"","url":"https://api.github.com/users/sethshoultes","html_url":"https://github.com/sethshoultes","followers_url":"https://api.github.com/users/sethshoultes/followers","following_url":"https://api.github.com/users/sethshoultes/following{/other_user}","gists_url":"https://api.github.com/users/sethshoultes/gists{/gist_id}","starred_url":"https://api.github.com/users/sethshoultes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sethshoultes/subscriptions","organizations_url":"https://api.github.com/users/sethshoultes/orgs","repos_url":"https://api.github.com/users/sethshoultes/repos","events_url":"https://api.github.com/users/sethshoultes/events{/privacy}","received_events_url":"https://api.github.com/users/sethshoultes/received_events","type":"User","site_admin":false},"assignees":[{"login":"sethshoultes","id":235315,"node_id":"MDQ6VXNlcjIzNTMxNQ==","avatar_url":"https://avatars3.githubusercontent.com/u/235315?v=4","gravatar_id":"","url":"https://api.github.com/users/sethshoultes","html_url":"https://github.com/sethshoultes","followers_url":"https://api.github.com/users/sethshoultes/followers","following_url":"https://api.github.com/users/sethshoultes/following{/other_user}","gists_url":"https://api.github.com/users/sethshoultes/gists{/gist_id}","starred_url":"https://api.github.com/users/sethshoultes/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sethshoultes/subscriptions","organizations_url":"https://api.github.com/users/sethshoultes/orgs","repos_url":"https://api.github.com/users/sethshoultes/repos","events_url":"https://api.github.com/users/sethshoultes/events{/privacy}","received_events_url":"https://api.github.com/users/sethshoultes/received_events","type":"User","site_admin":false},{"login":"lorenzocaum","id":1079138,"node_id":"MDQ6VXNlcjEwNzkxMzg=","avatar_url":"https://avatars2.githubusercontent.com/u/1079138?v=4","gravatar_id":"","url":"https://api.github.com/users/lorenzocaum","html_url":"https://github.com/lorenzocaum","followers_url":"https://api.github.com/users/lorenzocaum/followers","following_url":"https://api.github.com/users/lorenzocaum/following{/other_user}","gists_url":"https://api.github.com/users/lorenzocaum/gists{/gist_id}","starred_url":"https://api.github.com/users/lorenzocaum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lorenzocaum/subscriptions","organizations_url":"https://api.github.com/users/lorenzocaum/orgs","repos_url":"https://api.github.com/users/lorenzocaum/repos","events_url":"https://api.github.com/users/lorenzocaum/events{/privacy}","received_events_url":"https://api.github.com/users/lorenzocaum/received_events","type":"User","site_admin":false}],"milestone":null,"comments":2,"created_at":"2018-09-25T01:22:44Z","updated_at":"2018-09-27T23:27:19Z","closed_at":null,"author_association":"MEMBER","pull_request":{"url":"https://api.github.com/repos/eventespresso/event-espresso-core/pulls/708","html_url":"https://github.com/eventespresso/event-espresso-core/pull/708","diff_url":"https://github.com/eventespresso/event-espresso-core/pull/708.diff","patch_url":"https://github.com/eventespresso/event-espresso-core/pull/708.patch"},"body":"## Problem this Pull Request solves\r\nFixes https://github.com/eventespresso/eventsmart.com-website/issues/45\r\n\r\nSo previously, for tag archive requests, we would first query the db and assemble an array for EVERY SINGLE EXISTING TAG associated with EE_Events or EE_Venues via a single query. The site in question on EventSmart has nearly 700 tags and that query would timeout. Not exactly sure why (j/k). So the work in this branch, replaces that maga query with one that uses the tag from the request and only returns an EE_Term object if that tag is associated with any EE_Events or EE_Venues.\r\n\r\n\r\n## How has this been tested\r\nvia browser only\r\n\r\n\r\n## Checklist\r\n\r\n* [ ] I have added a changelog entry for this pull request\r\n* [x] I have read the documentation relating to systems affected by this pull request, see https://github.com/eventespresso/event-espresso-core/tree/master/docs\r\n* [x] User input is adequately validated and sanitized\r\n* [x] all publicly displayed strings are internationalized (usually using `esc_html__()`, see https://codex.wordpress.org/I18n_for_WordPress_Developers)\r\n* [x] My code is tested.\r\n* [x] My code follows the Event Espresso code style.\r\n* [x] My code has proper inline documentation.\r\n* [x] My code accounts for when the site is Maintenance Mode (MM2 especially disallows usage of models)\r\n"},"comment":{"url":"https://api.github.com/repos/eventespresso/event-espresso-core/issues/comments/425273753","html_url":"https://github.com/eventespresso/event-espresso-core/pull/708#issuecomment-425273753","issue_url":"https://api.github.com/repos/eventespresso/event-espresso-core/issues/708","id":425273753,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNTI3Mzc1Mw==","user":{"login":"lorenzocaum","id":1079138,"node_id":"MDQ6VXNlcjEwNzkxMzg=","avatar_url":"https://avatars2.githubusercontent.com/u/1079138?v=4","gravatar_id":"","url":"https://api.github.com/users/lorenzocaum","html_url":"https://github.com/lorenzocaum","followers_url":"https://api.github.com/users/lorenzocaum/followers","following_url":"https://api.github.com/users/lorenzocaum/following{/other_user}","gists_url":"https://api.github.com/users/lorenzocaum/gists{/gist_id}","starred_url":"https://api.github.com/users/lorenzocaum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lorenzocaum/subscriptions","organizations_url":"https://api.github.com/users/lorenzocaum/orgs","repos_url":"https://api.github.com/users/lorenzocaum/repos","events_url":"https://api.github.com/users/lorenzocaum/events{/privacy}","received_events_url":"https://api.github.com/users/lorenzocaum/received_events","type":"User","site_admin":false},"created_at":"2018-09-27T23:27:19Z","updated_at":"2018-09-27T23:27:19Z","author_association":"MEMBER","body":"I tested this and it looks good. @sethshoultes could you test as well please?"}}
{"actor":{"display_login":"lorenzocaum"}}