Reply To: [Resolved] Very slow queries
Actually that particular query will most probably be querying more than 60k records. You have 60k users, but the query in bp-activity-classes.php on line 387 is querying activity items. Considering an activity item gets added each time a user registers, changes their avatar, writes an update, a comment, a reply etc, then I’d guess there will be far more than just 60k rows.