I don’t get the buddypress friend system. (wp_bp_friends)

Let say you have 100k members and each of them have minimal 10 friends ,does that mean that your wp_pb_friends table will have 1 million cells?
If so ,Is that bad for performance?

[@r-a-y Keymaster 13 years, 11 months ago]

If user #1 becomes a friend of user #2, then the wp_bp_friends will add only 1 entry to the wp_bp_friends DB, not two.

Hope that helps.

[@hugesuccess Member 13 years, 8 months ago]

Also, it’s not so much a matter of table size as it is table design. A properly designed database would not have a problem with handling 1 million or 10 million cells in a table.