Reply to thread

We did a mass user cleanup (about 120K records) and I noticed that the cleanup jobs were extremly slow, it seemd like it would take forever to complete

So I took a look as to why it did take so long and noticed that it does full table scans on a couple tables, epecially some that had a few 100K records,

I am not sure if it's worth considering that, but adding indexes on

• xf_mg_media_item.last_comment_user_id
• xf_mg_album.last_comment_user_id
• xf_moderator_log.content_user_id
• xf_conversation_master.last_message_user_id
• xf_conversation_user.last_message_user_id

(We've had like 500K media items)

Significantly speeeded up things, a remaining chunk of ~80K jobs was completed within a few minutes while the previous 40K took over an hour.

[ATTACH=full]189745[/ATTACH]