Slow response searching through users

I’m wondering if you could confirm there’s no known issues with the response time on searching through users. We have a site with a little under 6000 users that takes well over 30 seconds (and sometimes over a minute) to search for a user.

It’s not a shared hosting issue, btw, it’s on a dedicated server and quite quick on nearly everything else.

Hi Skip,

There are no known issues that we’re aware of. Searching through the WordPress users is definitely a database-heavy operation, so the bottleneck could be your database.

yes, that ended up being it. for the benefit of anyone finding this later, it seems that the addition of an index sped it up from minutes to seconds, which is probably good enough. fyi, the sql to run is:

create index user_key on wp_usermeta(user_id, meta_key);

Thank you for the information, Skip! :)