{"action":"created","issue":{"url":"https://api.github.com/repos/OpenRIAServices/TestIssues/issues/83","labels_url":"https://api.github.com/repos/OpenRIAServices/TestIssues/issues/83/labels{/name}","comments_url":"https://api.github.com/repos/OpenRIAServices/TestIssues/issues/83/comments","events_url":"https://api.github.com/repos/OpenRIAServices/TestIssues/issues/83/events","html_url":"https://github.com/OpenRIAServices/TestIssues/issues/83","id":127289655,"number":83,"title":"Indexed EntitySet","user":{"login":"STAH","id":2418242,"avatar_url":"https://avatars.githubusercontent.com/u/2418242?v=3","gravatar_id":"","url":"https://api.github.com/users/STAH","html_url":"https://github.com/STAH","followers_url":"https://api.github.com/users/STAH/followers","following_url":"https://api.github.com/users/STAH/following{/other_user}","gists_url":"https://api.github.com/users/STAH/gists{/gist_id}","starred_url":"https://api.github.com/users/STAH/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/STAH/subscriptions","organizations_url":"https://api.github.com/users/STAH/orgs","repos_url":"https://api.github.com/users/STAH/repos","events_url":"https://api.github.com/users/STAH/events{/privacy}","received_events_url":"https://api.github.com/users/STAH/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/OpenRIAServices/TestIssues/labels/CodePlex","name":"CodePlex","color":"ededed"},{"url":"https://api.github.com/repos/OpenRIAServices/TestIssues/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-01-18T18:51:46Z","updated_at":"2016-01-18T18:51:47Z","closed_at":null,"body":"<sub>This issue was imported from [CodePlex](http://openriaservices.codeplex.com/workitem/6)</sub>\r\n\r\n**[ColinBlair](https://github.com/ColinBlair)** <sup>wrote 2013-10-03 at 20:01</sup>\r\nWhen lots of rows are in-memory, calculating foreign key relationships can become very slow. Adding indexes to the EntitySet would greatly help performance in those situations."},"comment":{"url":"https://api.github.com/repos/OpenRIAServices/TestIssues/issues/comments/172621609","html_url":"https://github.com/OpenRIAServices/TestIssues/issues/83#issuecomment-172621609","issue_url":"https://api.github.com/repos/OpenRIAServices/TestIssues/issues/83","id":172621609,"user":{"login":"STAH","id":2418242,"avatar_url":"https://avatars.githubusercontent.com/u/2418242?v=3","gravatar_id":"","url":"https://api.github.com/users/STAH","html_url":"https://github.com/STAH","followers_url":"https://api.github.com/users/STAH/followers","following_url":"https://api.github.com/users/STAH/following{/other_user}","gists_url":"https://api.github.com/users/STAH/gists{/gist_id}","starred_url":"https://api.github.com/users/STAH/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/STAH/subscriptions","organizations_url":"https://api.github.com/users/STAH/orgs","repos_url":"https://api.github.com/users/STAH/repos","events_url":"https://api.github.com/users/STAH/events{/privacy}","received_events_url":"https://api.github.com/users/STAH/received_events","type":"User","site_admin":false},"created_at":"2016-01-18T18:51:47Z","updated_at":"2016-01-18T18:51:47Z","body":"**[ColinBlair](https://github.com/ColinBlair)** <sup>wrote 2013-11-04 at 20:32</sup>\r\nThe issue is primarily on the parent object finding the children, not the other way around. The parents key is already indexed, but the child's foreign key is not indexed.  \r\n"}}