I have the need for a pretty featureless protected page on the site I am working on. It has roughly 9000 members and is completely unusable. Loging in a member can take roughly 20 seconds.

Members.Login(model.Username, model.Password)

Updating a members is the same

            var u = memberService.GetByUsername(model.Username);
            string p = System.Web.Security.Membership.GeneratePassword(6, 0);
            memberService.SavePassword(u, p);

When dealing with the cache the page is quick but as soon as I need a database query that accesses the members data the site barely functions.

My login is located in a SurfaceController. 9000 members does not seem like it should be enough to cause 20 second delays.

The members have no custom properties and there is only one member role and group.