"I have spent significant time perusing code and table design. One thing I found is that several core member queries query the bp_xprofile_data table on the field_id and value fields simultaneously. Once you hit a couple thousand users this will impact performance tremendously by adding an index with the field_id first and the value second you would keep MySQL from performing a table scan. Since user_id is usually what is returned you could also add this to the index and MySQL would serve the data straight from the index giving you a dramatic performance boost in user searches. Here is the definition I would propose. INDEX fid_v_uid (field_id