On a database of 100,000 entries, implement full text search on the title and description field.
The search function should be optimized for search, rather than updates, and cacheing searches should be part of the solution.
Please supply harness scripts to test the solution with a list of queries terms in a file. I will supply the database table, and will run benchmark tests on the speed.
A solution using sphinx is expected. Please do not bid if you have no full-text-search experience.