Reply to thread

Per the quoted MySQL slow query log:

xf_edit_history ~310000

xf_user_alert ~490000


It has only been ~3 months since migrating to a version of XF with the edit history.  Of those alerts, only ~144000 are unviewed.


Adding the index to xf_edit_history only took ~20 seconds, and ~6 seconds for xf_user_alert. But that is obviously very hardware and data volume dependant.


Back
Top Bottom