Recently, our server has been hit HARD by the user registration bots, and is causing SERIOUS database bloat, which subsequently is causing performance issues server wide. In some cases, we have sites with over 30,000 users. I've since disabled the user registrations on all of our sites, but now I am left with the problem of deleting all these fake user accounts / profiles.
I've tried using the script
Set Authorised='False' where Authorised='True'"
and then "deleting unauthorized users", but on the site I tried that on, it completely crashed the whole server. (i attempted to delete around 1500 users at once, which I imagine was too much of a strain on the server)
Can anyone help me figure out how I can delete the users in a different way? Is there an SQL script I can run that will delete unauthorized users from the server side, rather than from the front end DNN side? Would this help?
Any advice on getting rid of massive amounts of users / profiles on our server would be greatly appreciated.