Millions of anonymous ASP.Net profiles!?

Posted by Mantorok on Stack Overflow See other posts from Stack Overflow or by Mantorok
Published on 2010-05-04T10:13:03Z Indexed on 2010/05/04 10:18 UTC
Read the original article Hit count: 368

Filed under:
|

Hi all, some advice needed!

Our website receives approximately 50,000 hits a day, and we use anonymous ASP.Net membership profiles/users, this is resulting in millions (4.5m currently) of "active" profiles and the database is 'crawling', we have a nightly task that cleans up all the inactive ones.

There is no way that we have 4.5m unique visitors (our county population is only 1/2 million), could this be caused by crawlers and spiders?

Also, if we have to live with this huge number of profiles is there anyway of optimising the DB?

Thanks

Kev

© Stack Overflow or respective owner

Related posts about ASP.NET

Related posts about membership