After SqlMembership and Roles Site is Slow


i have adopted the technique of sqlmembership and roles. but after that site is getting very slow. i know there are some side effects of using enable trimming on sitemap items.

but it is really very to understand that what is the reason. what are the performance issues i should keep in mind while applying such settings......

Muhammad Shoaib
Human Knowledge belong to the World!
5/1/2009 10:48:13 AM
๐Ÿ“ƒ 27051 articles.
โญ 1 followers.

๐Ÿ’ฌ 2 Replies
๐Ÿ‘๏ธโ€๐Ÿ—จ๏ธ 1381 Views


Generally, it'll be fine if you enable membership and role in application. Thus I guess whether it's caused by SQL Server. Do you use a local or remote SQL Server? Is the SQL Server busy? Also, is the retrieved data from database big?


David Qian
Microsoft Online Community Support

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
5/5/2009 6:12:01 AM


ย is the Aspnet membership running onย a sql server a good solution for a site that wants to be very large? Maybe you could point us to some popular larger sites running it? I know myspace seems to be labled a .net site, go seems to have .aspx files being served - any info you can provide would be great. I know there is a lot of other factors that could play into a sql server being slowed down, open datareaders, a ton of open connections, bad queries, incorrect page file set up etc... but on a whole is the aspnet membership made for a big time site?


ย Jeff

5/5/2009 6:36:12 AM