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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
