Aerik Sylvan wrote:
I wrote a "suggest" function for finding part numbers for a request form at work - enabling multi-word search is really useful and powerful. I haven't looked at your code, so I don't know if you're using a keyword index, or LIKE SQL functions. I set mine up to require at least 4 characters and to to break on whitespace, so the SQL (pseudocode) is WHERE LIKE(wordone) AND LIKE(wordtwo) and so on.
This is, of course, the most obvious and most naive solution. For a data set as large as Wikipedia's list of article titles, this is far too slow and inefficient and would kill the site for everyone if it was used on the live database.
Timwi