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: 396
ASP.NET
|membership
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