Right now I use a single WP table to feed several sites. We have about 72K users and I have started noticing that to see the “Users” page it takes about 30 seconds on our otherwise pretty fast server. Are there any scalability issues I should worry about and anything I can do to get the user functions working quicker?
Extra Info: The user table is added to each night using employee data. There is nothing writing to the user table. We do allow users to edit some extra fields that get put into the metauser table. However there is no sign-up or registration. All of the sites simply define the user/meta tables in the config.
2 s
For every scaling question you can look at wordpress.com and see how big they are. I do’t know the details but I think that with all the users of wordpress.com itself, akismet users and jetpack users, an estimate of 1M users can’t be totally wrong.. In addition so far as far as auttomatic people say they are running vanilla wordpress (or very very close to it) with plugins.
So can it scale scale above 100k users? seems like the answer is an easy yes. So how much time does it take them to load the users page? I think the answer is that wordpress do not have the tools to easily admin this amount of info and just because of UX reasons you will never want to go to the users page when you have so many users.
So maybe there are two separate questions here, Can wordpress scale to have 100k user? yes! Does vanilla wordpress give you the tools to easily admin so many users? probably not.
