Albert Wiersch wrote: ↑
Thu Mar 29, 2018 4:47 am
So... if I'm reading this right, all the SQL queries are fast but something happens after QUERY #7 and before QUERY #8 that takes a very long time and spikes the CPU... so what is it doing between these two queries that is taking such a long time?
You'd need to profile the script to see where most of the time is spent. That's something that's easier to do on a development server rather than live.
If you post a copy of your
it may reveal some important information. Maybe something related to PCRE.
You may also try to edit
$hilit = str_replace(' ', '|', $hilit);
$hilit = '';
to see if disabling this feature makes any difference with the slow search terms.
If you have a list of censored words, you can try clearing it and see if it makes a difference. Obviously, those changes would need to be reverted after use.