Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • RIchard 10 posts 110 karma points
    May 04, 2018 @ 08:36
    RIchard
    0

    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.

    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.

  • Alex Skrypnyk 6131 posts 23950 karma points MVP 7x admin c-trib
    Aug 01, 2018 @ 13:55
    Alex Skrypnyk
    0

    Hi RIchard

    Did you solve a performance issue? It would be really cool if you share with us :)

    Thanks,

    Alex

Please Sign in or register to post replies

Write your reply to:

Draft