{"action":"created","issue":{"url":"https://api.github.com/repos/TerriaJS/magda/issues/1282","repository_url":"https://api.github.com/repos/TerriaJS/magda","labels_url":"https://api.github.com/repos/TerriaJS/magda/issues/1282/labels{/name}","comments_url":"https://api.github.com/repos/TerriaJS/magda/issues/1282/comments","events_url":"https://api.github.com/repos/TerriaJS/magda/issues/1282/events","html_url":"https://github.com/TerriaJS/magda/issues/1282","id":335062523,"node_id":"MDU6SXNzdWUzMzUwNjI1MjM=","number":1282,"title":"Remove use of COUNT(*) in registry api","user":{"login":"AlexGilleran","id":900555,"node_id":"MDQ6VXNlcjkwMDU1NQ==","avatar_url":"https://avatars1.githubusercontent.com/u/900555?v=4","gravatar_id":"","url":"https://api.github.com/users/AlexGilleran","html_url":"https://github.com/AlexGilleran","followers_url":"https://api.github.com/users/AlexGilleran/followers","following_url":"https://api.github.com/users/AlexGilleran/following{/other_user}","gists_url":"https://api.github.com/users/AlexGilleran/gists{/gist_id}","starred_url":"https://api.github.com/users/AlexGilleran/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/AlexGilleran/subscriptions","organizations_url":"https://api.github.com/users/AlexGilleran/orgs","repos_url":"https://api.github.com/users/AlexGilleran/repos","events_url":"https://api.github.com/users/AlexGilleran/events{/privacy}","received_events_url":"https://api.github.com/users/AlexGilleran/received_events","type":"User","site_admin":false},"labels":[{"id":429367924,"node_id":"MDU6TGFiZWw0MjkzNjc5MjQ=","url":"https://api.github.com/repos/TerriaJS/magda/labels/bug","name":"bug","color":"ee0701","default":true},{"id":879686295,"node_id":"MDU6TGFiZWw4Nzk2ODYyOTU=","url":"https://api.github.com/repos/TerriaJS/magda/labels/priority:%20release-blocker","name":"priority: release-blocker","color":"d93f0b","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-06-23T03:09:00Z","updated_at":"2018-06-24T23:30:58Z","closed_at":null,"author_association":"MEMBER","body":"### Problem description\r\nThere's a number of places where the registry uses `COUNT(*)`, which is bad https://dba.stackexchange.com/questions/184685/why-is-count-slow-when-explain-knows-the-answer.\r\n\r\nThese statements are getting logged by Google Cloud SQL, which I presume means they're executing really slowly.\r\n\r\nEither way we should change them to `COUNT(id)`"},"comment":{"url":"https://api.github.com/repos/TerriaJS/magda/issues/comments/399797720","html_url":"https://github.com/TerriaJS/magda/issues/1282#issuecomment-399797720","issue_url":"https://api.github.com/repos/TerriaJS/magda/issues/1282","id":399797720,"node_id":"MDEyOklzc3VlQ29tbWVudDM5OTc5NzcyMA==","user":{"login":"maxious","id":81432,"node_id":"MDQ6VXNlcjgxNDMy","avatar_url":"https://avatars1.githubusercontent.com/u/81432?v=4","gravatar_id":"","url":"https://api.github.com/users/maxious","html_url":"https://github.com/maxious","followers_url":"https://api.github.com/users/maxious/followers","following_url":"https://api.github.com/users/maxious/following{/other_user}","gists_url":"https://api.github.com/users/maxious/gists{/gist_id}","starred_url":"https://api.github.com/users/maxious/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maxious/subscriptions","organizations_url":"https://api.github.com/users/maxious/orgs","repos_url":"https://api.github.com/users/maxious/repos","events_url":"https://api.github.com/users/maxious/events{/privacy}","received_events_url":"https://api.github.com/users/maxious/received_events","type":"User","site_admin":false},"created_at":"2018-06-24T23:30:58Z","updated_at":"2018-06-24T23:30:58Z","author_association":"COLLABORATOR","body":"That question is about MySQL btw, the PostgreSQL solutions including autosample are great! https://stackoverflow.com/questions/7943233/fast-way-to-discover-the-row-count-of-a-table-in-postgresql"}}
{"actor":{"display_login":"maxious"}}