The only aspect of the ASP.NET membership model that I have complaints about scalability is that SqlProfileProviderwhich provides support for the profile on the SQL server. Due to the structure of the SQL database regarding user profiles, it is difficult to execute queries that aggregate profile information through a user database.
You may find it useful to consider a discussion on this issue: Membership in ASP.NET with over 2 million users - any problem (s)?
source
share