Last post Oct 02, 2016 07:14 AM by Yohann Lu
Sep 30, 2016 05:51 PM|Gaston Leblanc|LINK
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?
Oct 02, 2016 07:14 AM|Yohann Lu|LINK
Hi Gaston Leblanc,
It looks to me as if the membership routines are slowing down my website.
I found the following links discusses performance optimizations when using ASP.NET membership. You can refer them.
Performance Considerations for Applications Using Services:
Optimize ASP.NET Membership Stored Procedures for greater speed and scalability: