MySQL FULLTEXT Optimization

[Delixe]

I found one way which is great with speeds:

 

SELECT * FROM `fmc_archive_dev` WHERE

(MATCH(itm_desc) AGAINST('Zune') OR

MATCH(itm_desc) AGAINST('xss') OR

MATCH(itm_desc) AGAINST('ajax') OR

MATCH(itm_desc) AGAINST('rsnake') OR

MATCH(itm_desc) AGAINST('virus') OR

MATCH(itm_desc) AGAINST('porn') OR

MATCH(itm_desc) AGAINST('final fantasy') OR

MATCH(itm_desc) AGAINST('domain') OR

MATCH(itm_desc) AGAINST('web 2.0') OR

MATCH(itm_desc) AGAINST('web development') OR

MATCH(itm_desc) AGAINST('steve nash') OR

MATCH(itm_desc) AGAINST('reverse engineering'))

AND archived_on > 1175150209

 

How do you add multiple columns to the MATCHES? Is there a way to optimize this more?

[fenway]

Well, you could make a multi-column fulltext index -- I think 16 columns is the max