axel at uni-paderborn
Feb 9, 2002, 9:58 AM
Post #1 of 2
> 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.