James Keeline wrote: > --- John Black <[EMAIL PROTECTED]> wrote: > Looking at the comments for the very page you link suggests that some people > have exceptionally poor performance from fulltext searchers. Perhaps they > don't have the correct indexes on their multi-million-row tables but it does > not seem to be universal that fulltext searches are faster than LIKE searches. > James
I looked at the comments about slow performance and as far as I can tell nobody gives details on which columns where added to the fulltext. Incorrect use will degrade performance. Others with performance issues have stated that they are having problems with COUNT(*) statements. Most say that they are running their queries on 6+ million row tables but do not specify how much data and what kind of data they contain. Running LIKE on a table will need additional code to sort the result by relevance afterwards which is something fulltext can provide.... there is really not enough information to draw any conclusion. I can only recommend to give it a try, fulltext works great and as far as my own test go it works better then like. Large projects like phpBB and other major forums all use FULLTEXT. But as we all know, there is no solution that will work for everybody, after all some people actually like to use Windows as a server OS....
