Repair tool “Count friends for each user” doesn't scale to 150k users.

[DJPaul]

From ​https://buddypress.org/support/topic/friends-module-not-working-after-clicking-on-buddypress-repair-tools/

I went to the “Buddypress Repair Tools” and clicked on: “Count friends for each user”
I’ve got 150.000 users in my website. It looks like it didn’t complete the script, and it brought back an error 500 page.
So, the wp-admin is throwing an error 500 if “Friends” module of Buddypress is active.
I have deactivated it through the database, editing the wp_options section. But now my users cannot add friends.
Is there any way to run the script outside the wp-admin area, or maybe directly to the mysql database?

[tw2113]

This sounds like it'd be a good potential WP-CLI item. Batch processing anything at that amount is going to be a server performance issue.

[espellcaste]

We have a CLI command he can use.

wp bp tool repair friend-count

For sites with such a high number of users, BP-CLI is the recommended approach. For that reason, I'm closing this one as maybelater.