Hi All, I am new to this Forum and after long years back in application development. In my past life before MVC days I developed public facing sites with small volume of users in the range of say 10k and we never had any issue in managing user base of that size. The Site was a part of our Corporate infrastructure and resource was excellent.
Right now I am in the process of developing a site and expected user base will be close to a million in a year and the site, database (MSSQL) all hosted. I have some concern if we use Webmatix's Simple Membership provider for authentication the response will be slow.

Looking for guidance from the experts the type of provider one should select for authenticating a large user base.

Thank you All.