WordPress usermeta scaling for thousands of users
The size of the table isn’t really the issue, the queries you’re running on that table might be. For example, if you’re selecting users based on data stored in the user-meta table, then that query will be highly unoptimized, because meta_value is not an indexed field. In which case you may need to add extra … Read more