List:General Discussion« Previous MessageNext Message »
From:Chris Sansom Date:April 11 2006 2:45pm
Subject:Re: Problem with 'or' in 'where' clause? (longish)
View as plain text  
At 9:28 -0500 11/4/06, mos wrote:
>         If you keep it in 5 different tables, the search will be as 
>slow as molasses in January because of the joins. I'd recommend 
>using FullText search on the text field.

Hi Mike

Thanks for the rapid response! OK - I've set all those text fields as 
FullText indices...

>You *may* be able to do a Merge table on the 5 tables so MySQL sees 
>it as 1 table. I'm not sure which of these features are available in 
>3.23

 From 3.23.25 according to the docs, and it's 3.23.58 on the server, 
so I should be able to do this.

>Either that or limit each table to about 10 rows.<g>

No can do, unfortunately!

>         The other alternative that just occurred to me is to do 5 
>separate searches, each on only 1 table using a full text index. 
>Then join the results. That could be faster than what you're doing 
>now.

Hmmm... this is getting a bit beyond my relatively short experience. 
How do I go about joining the results without subqueries?

-- 
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/

What contemptible scoundrel has stolen the cork to my lunch?
    -- W.C. Fields
Thread
Problem with 'or' in 'where' clause? (longish)Chris Sansom11 Apr
  • Re: Problem with 'or' in 'where' clause? (longish)mos11 Apr
    • Re: Problem with 'or' in 'where' clause? (longish)Chris Sansom11 Apr
  • Re: Problem with 'or' in 'where' clause? (longish)Barry11 Apr
    • Re: Problem with 'or' in 'where' clause? (longish)Chris Sansom11 Apr
      • Re: Problem with 'or' in 'where' clause? (longish)Barry11 Apr
        • Re: Problem with 'or' in 'where' clause? (longish)Chris Sansom11 Apr
          • Re: Problem with 'or' in 'where' clause? (longish)Barry11 Apr
            • Re: Problem with 'or' in 'where' clause? (longish)Barry11 Apr
            • Re: Problem with 'or' in 'where' clause? (longish)Chris Sansom11 Apr
  • Re: Problem with 'or' in 'where' clause? (longish)Barry11 Apr