{"action":"created","issue":{"url":"https://api.github.com/repos/sonata-project/SonataDatagridBundle/issues/44","repository_url":"https://api.github.com/repos/sonata-project/SonataDatagridBundle","labels_url":"https://api.github.com/repos/sonata-project/SonataDatagridBundle/issues/44/labels{/name}","comments_url":"https://api.github.com/repos/sonata-project/SonataDatagridBundle/issues/44/comments","events_url":"https://api.github.com/repos/sonata-project/SonataDatagridBundle/issues/44/events","html_url":"https://github.com/sonata-project/SonataDatagridBundle/issues/44","id":174559861,"number":44,"title":"Distinct on primary auto increment key","user":{"login":"TimoFrenzel","id":4244473,"avatar_url":"https://avatars.githubusercontent.com/u/4244473?v=3","gravatar_id":"","url":"https://api.github.com/users/TimoFrenzel","html_url":"https://github.com/TimoFrenzel","followers_url":"https://api.github.com/users/TimoFrenzel/followers","following_url":"https://api.github.com/users/TimoFrenzel/following{/other_user}","gists_url":"https://api.github.com/users/TimoFrenzel/gists{/gist_id}","starred_url":"https://api.github.com/users/TimoFrenzel/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TimoFrenzel/subscriptions","organizations_url":"https://api.github.com/users/TimoFrenzel/orgs","repos_url":"https://api.github.com/users/TimoFrenzel/repos","events_url":"https://api.github.com/users/TimoFrenzel/events{/privacy}","received_events_url":"https://api.github.com/users/TimoFrenzel/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-09-01T15:51:00Z","updated_at":"2016-09-01T15:51:58Z","closed_at":null,"body":"Sonata\\DatagridBundle\\Datagrid\\Pager\r\n\r\nWe have several million records in the table.\r\nIt noticed that the ListView needs more than 3 minutes to open the page.\r\n\r\nThis file is the problem.\r\nIt is made a count (distinct id).\r\nHowever, the id is always an autoincrement primary key.\r\nThis slows the whole considerably.\r\n\r\n\r\nAnd here too: Sonata\\DatagridBundle\\Datagrid\\ProxyQuery"},"comment":{"url":"https://api.github.com/repos/sonata-project/SonataDatagridBundle/issues/comments/244123864","html_url":"https://github.com/sonata-project/SonataDatagridBundle/issues/44#issuecomment-244123864","issue_url":"https://api.github.com/repos/sonata-project/SonataDatagridBundle/issues/44","id":244123864,"user":{"login":"greg0ire","id":657779,"avatar_url":"https://avatars.githubusercontent.com/u/657779?v=3","gravatar_id":"","url":"https://api.github.com/users/greg0ire","html_url":"https://github.com/greg0ire","followers_url":"https://api.github.com/users/greg0ire/followers","following_url":"https://api.github.com/users/greg0ire/following{/other_user}","gists_url":"https://api.github.com/users/greg0ire/gists{/gist_id}","starred_url":"https://api.github.com/users/greg0ire/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/greg0ire/subscriptions","organizations_url":"https://api.github.com/users/greg0ire/orgs","repos_url":"https://api.github.com/users/greg0ire/repos","events_url":"https://api.github.com/users/greg0ire/events{/privacy}","received_events_url":"https://api.github.com/users/greg0ire/received_events","type":"User","site_admin":false},"created_at":"2016-09-01T15:51:58Z","updated_at":"2016-09-01T15:51:58Z","body":"Can you have a look at the history to find the commit where this keyword was added?"}}
{"actor":{"display_login":"greg0ire"}}