BuddyPress.org

Hi,

I know that with the new update last_activity is stored in bp_activity table. Which helps a lot. But I don’t understand why it’s still using last_activity from the usermeta table when I performed a search. I have a really big database with over a million users and a good server, the members page loads fast, but when I do a search it never loads the results. Using show full process list in mysql I could see that the query causing the problem is calling to the usermeta table. Where in the code is that table being called for the search? and also is calling the last_activity from usermeta table when opening a single profile. I need to modify that query.