Reply To: Slow for logged-out users
Hey,
The fix for that is coming in the next release of buddy press. Or at least for the part of the problem.
You most likely get 50% of your problem from these two in my case with 6k users these amounted to the respective query execution times (from new relic), I also run buddypress + rtmedia (which is the source of this problem) as described in this ticket:
bp_friends_prime_mentions_results – 10,000+ ms
bp_core_fetch_avatar – 6,000+ ms
Here’s a fix:
https://buddypress.trac.wordpress.org/changeset/11561
You’ll still likely stay with this massive query even for logged out users:
WP_User_Query::query on average right now it’s at around 7,500ms.
Good news is that with HHVM site runs much faster due to object caching straight after enabling it.
I’ve also played around with various hosts, flywheel & wpengine sucked. What works well is Kinsta with HHVM enabled, they can also check your database and help you move to InnoDB if you’re using another one.
Anyway man hope this helps.
Best,
M.
