i have adopted the technique of asp.net 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......
Human Knowledge belong to the World!
Generally, it'll be fine if you enable membership and role in asp.net 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?
Microsoft Online Community Support
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
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 daddy.com 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?