[@n0madpl Participant 7 years, 6 months ago]

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() – Used by the Activity component’s @mentions to print a JSON list of the current user’s friends.

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.

[@n0madpl Participant 7 years, 6 months ago]

Hey,

I’m experiencing a similar issue with 6k members, I can’t imagine the size of requests at 30k+…

It seems like mine was triggered by use of RTmedia, cause is described in this ticket, together with a patch:
https://buddypress.trac.wordpress.org/ticket/7530

If you’re using their plugin/s this could have been a cause.

Btw cool site 🙂 and congrats on the user count.

[@n0madpl Participant 7 years, 6 months ago]

@mercime?

[@n0madpl Participant 7 years, 6 months ago]

I’ve also noticed that switching to HHVM improves the performance of the site a lot… but seems like this single query messes up the performance of my whole site, as it’s included in loading of many pages.

But before I switch permanently from PHP 7 to HHVM I’d like to solve this issue. Any ideas?