Re: Full-text search slower than like

[Rick James]

What values do you get for these:

SELECT COUNT(*)
   FROM pilz_pilz
   WHERE MATCH pilz AGAINST ('bole*' IN boolean MODE);
SELECT COUNT(*)
   FROM pilz_pilz
   WHERE MATCH pilz AGAINST ('+bole*' IN boolean MODE);
SELECT COUNT(*)
   FROM pilz_pilz
   WHERE            pilz LIKE '%bole%';

And see if things get faster after this:
OPTIMIZE TABLE pilz_pilz;



Edited 1 time(s). Last edit at 02/10/2010 08:35PM by Rick James.