James Keeline wrote: > --- John Black <[EMAIL PROTECTED] technologies. org> 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.... *********************** Thanks. Two more questions based on this: 1) I have to select from eight similar tables (table1, table2 table3 etc..) like this. How do you select form that many table, what is the syntax? Do you repeat the whole select queary and use UNION eight times or how? I tried commas in the query but it didnt work. (table1, table2, table3) If there is a shortcut of writing instead of joining eight queries with UNION, is one way more efficient than the other? 2) Can you use OR statement if you were to select from more than two columns? Such as article title, articlebody and additionalcolumn? If so how? Do you just place another OR so there are two ORs now? I tried and it looks like it works, but dont have enough data in my db yet to be sure.... Messages in this topic (5) Reply (via web post) | Start a new topic Messages | Polls Please remember to write your response BELOW the previous text. Community email addresses: Post message: [email protected] Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Change settings via the Web (Yahoo! ID required) Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ [Non-text portions of this message have been removed]
