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]

Reply via email to