RE: Full Text Index on Large Tables - Not Answered

[Robert A. Rosenberg]

At 19:02 -0700 on 06/18/2004, Paul Chu wrote about Re: Full Text 
Index on Large Tables  - Not Answered:

Appreciate any help at all
Thanks, Paul

-----Original Message-----
From: Paul Chu [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 10:16 AM
To: [EMAIL PROTECTED]
Subject: Full Text Index on Large Tables
Hi,
If I have a table with 100 - 200 million rows and I want to search
For records with specific characteristics.
Ex.
Skills varchar(300)
        Skill id's 10           15
                        Accounting finance etc.
Is it advisable to created a field with skill ids and then use the
Skills column in a full text index
Thanks for your help, Paul
The best way of doing this is to create 2 additional tables for the 
skills. One table has as its PK a skill number and as a separate 
indexed column a text description. The second table has as its PK 
(and total content) the Skill Number and the UserID (in that order). 
To search for the skills, you just search the 2nd table on Skill 
Number (after getting it from the first table) and Join the result to 
the User Table.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]