XF 1.5 Big forum: very slow user deletion (1 minute for 1 deletion)

[nocte]

As our forum grows the user deletion takes longer and longer (currently up to 1 minute).

Would it make a big difference if we try to prune these tables (we don't have autoprune here currently):

• IP logs
• user change log

The likes table is also very big: 100s of millions of likes.

We have already added some indexes to mysql tables like described here: -> https://xenforo.com/community/threads/xf-service-user-deletecleanup-causes-full-table-scans.157291/