SELECT * FROM cur WHERE (cur_title NOT LIKE
"S") AND (cur_text LIKE "S" )
ORDER BY cur_title
seems to be a big offender. That's the
special_dosearch query, I think.
Yes. That searches linearly through the whole database to search for a
string. That's a killer. It's like our old UseMod search before Jimbo wrote
an indexed one. A FULLTEXT index, together with MATCH instead
of LIKE, should give a major improvement.
Axel