Not planned [1.x] Improve user deletion

grisha2217

Active member
6k bots are registered on my forum, i'm trying to delete theim by mass users update, but deletion process for every bot is very slow, because script executes 30+ SQL queries for every user. Total 180k+ queries to delete 6k bots...

3o4UpXL.jpg



I suggest to execute every $db->delete() function with all needed user ids. A query will be like it:
SQL:
DELETE FROM xf_profile_post WHERE user_id IN (1,2,3,4,5,6,7,8,9,10)


It will be faster than current solution... Sorry for my english.
 
Upvote 0
This suggestion has been closed. Votes are no longer accepted.
There’s little point in marking suggestions for XF1 as there will be no further feature releases for XF1.

But even so, there isn’t really anything we can do here. The process isn’t as simple as just table deletions.

There’s a myriad of things we do when we delete users which extends beyond simply removing rows from a single table.
 
Top Bottom