Millions of anonymous ASP.Net profiles!?
- by Mantorok
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