My site's index.php (basically runs XenForo) is intermittently running extremely high CPU usage, which locks up my site for a minute or so.
I have disabled XenForo's user-based search function, as I don't need that functionality on my site.
XF_SEARCH_INDEX is by far my largest data-table in my database, with over 200,000 rows and counting.
QUESTION: If I am not using the front-end search function, can I DROP the entire XF_SEARCH_INDEX table? Will this stop it from having rows added?
Is anything else tied to or being using by this specific data-table? Like for SEO or other purposes?
If so, can I just select DROP table in phpmyadmin? And do you think this will reduce the CPU usage for my index.php as the database will be nearly cut in half if I were to drop this table.