shahdat45ict wrote:Nop support guest checkout features. These all are guest customers. To keep shopping cart and wishlist saved for anonymous users, nop automatically create guest user for each new browser instance ( cookie based ). You may want to enable Delete Guest scheduler task to delete guest account periodically, or you can delete guest account from admin manually ( admin -> system -> maintenance )
Today, I noticed that since September (after i upgraded to 3.40) I have also had 3,000-5,000 new customer accounts created every day! This was not a problem before I upgraded to 3.40. Even with your above explanation, I do not believe that we had enough genuine traffic to explain so many cookies being issued/records inserted, and I am sure that Google analytics reports will confirm. I assumed the delete guests scheduled task was working, because it runs daily with no reported errors...
So I guess this means that whatever bot is slamming my site with bogus customer registrations is also adding an item to it's shopping cart each time, or else the scheduled task would have deleted them, right?? So there are probably also hundreds of thousands of bogus CartItem records inserted since September???
OK, so this is a problem that I need to solve as soon as possible, but what is frustrating me right now, is the huge number of guest accounts per day that have accumulated since September. Hundreds of thousands.
If I try to use the delete guests tool in admin >> system >> maintenance, and specify more than one day in the date range, it errors almost immediately with a timeout. I can only clean-up one day at a time, and that takes a little more than an hour to complete... with the CPU pegged out for the entire time! SQL server is never using more than about 8% of the CPU, whereas the w3wp is using 85-95% constantly...
What I am hoping is that someone can suggest a way that I can 'clean-up' my customers table via SQL script that I can execute in SSMS so that the w3wp is not involved in the operation.
Best case scenario for me right now is to perform the operation nightly (very late at night) on one day, because i cannot afford my site to perform so poorly for too long of a time and risk google indexing problems...and just a manual clean up of one day, per day, I will never make enough progress...
HELP, Please!