Omar Al Zabir also published 10 ASP.NET Performance and Scaling Secrets with One of the Elements How to request ASP.NET 2.0 membership tables without dropping the site . This is mainly due to querying the database in such a way as to ensure that the correct indexes are being used. There is another profile tip on this list. Iām not sure that these tips are the same as those given in the article recommended by Matt.
I am sure that the Omar http://www.pageflakes.com/ website uses the ASP.NET membership provider for SQLMembership, and he will probably be a great person to talk to to decide whether this scenario is possible. Given his community efforts, Iām sure you could track him through contact sites. Ask him to post answers here!