Please upgrade to 2.1.x here.
The 2.0 branch is no longer being updated.
[GitHub Bug #895] Profile/Activity Pages Extremely Slow
Does anyone else have such an issue, when requesting any users profile page or viewing the activity feed, the pages 10-20s to load. No other pages have the issue. My forum isn't abnormally large, ~7k users with 100-200 online at a given time. Normal discussion and posting does not have this issue so the code/SQL specifically for these pages is doing something very wrong.
I'm not even sure how to debug this while keeping the site up. I don't know what further information would be useful to debug this so any help or queries would be appreciated.
*edit* This is running the latest Vanilla version, 188.8.131.52bug on github