locked
Membership database routines take a long time RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1422203677 posted

    I ran SQL profiler on my database as I use the website that interacts with it, and the resulting profile says that executing dbo.aspnet_Membership_GetUserByName takes 3216548 microseconds (over 3 seconds).  It looks to me as if the membership routines are slowing down my website.  Could that be because they do joins on 'uniqueIDs' which happen to take several bytes?  Or is there some other reason?  I will check whether the routine was altered from the original, but if this Microsoft-supplied security feature is at fault, is there a way to improve it?

    Thanks.

    Friday, September 30, 2016 5:51 PM

Answers