For those of you who aren't aware, if you're using XFES you can truncate the xf_search_index table, as it is no longer used.
On a large site, that will reduce the DB size by a considerable amount, (potentially) resulting in less server space being utilised, quicker backups, etc.
phpMyAdmin
SSH
On a large site, that will reduce the DB size by a considerable amount, (potentially) resulting in less server space being utilised, quicker backups, etc.
phpMyAdmin
Code:
TRUNCATE 'xf_search_index';
SSH
Code:
TRUNCATE TABLE xf_search_index;
Last edited: