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
