MySQL full-text search optimization using sphinx
How does it work? You simply install the sphinx software on your server, create a configuration file for the table you want to perform the searches on and run the indexing process. This will create a dictionary file that allows you to perform searches in less than a second, on huge tables.