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.
Slow performance when dealing with member api
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.
Updating a members is the same
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.
Hi RIchard
Did you solve a performance issue? It would be really cool if you share with us :)
Thanks,
Alex
is working on a reply...