Emacs opens files from one of my largest Git repositories very slowly. It looks like it spends most of that time waiting for `git diff-index -z HEAD -- <file>`.
Applying the workaround from comment 14 in that ticket works for me, but it seems like it would be better to address the problem closer to the root in the Emacs source and/or in Git.