Need Help ASAP - User Search causes backend to freeze

[kevinh]

Sorry to sound urgent, but this is a big week for our site and many users are logging in and registering... so I want to avoid as much hassle as I can.

Basically, I have had s2member installed and running for a couple weeks with no problems.

Our user database is around 3,000 with simultaneousness logins around 300-500 or so...
WP v. 3.0.4
s2pro v. 1.3.2
We're also running our WP install and our database on two separate servers. Not sure if there's a specific configuration that optimizes s2 to work better with this type of setup.

Everything was fine last night, but now this morning when I preform a search in the Users section it freezes the back-end for several minutes and eventually times out. When I first log in, the back-end is fast can switch to pages, comments, posts, etc... very fast.. but as soon as I do a search for users it freezes. I've deactivated all plugins (including s2) and it worked properly and fast. Then enabled s2 and the problem occurred again.

Thanks for the help.

[cschell]

I had this same exact issue. Searching for users did not work.

I finally had to re-install s2Membership and optimize the database in PHPMyAdmin. Several of the tables for s2 had very high overhead.

However now I'm having other admin issues. If you create a new page is your visual editor disabled?

Just trying to see if we're all having the same issues.