[BNM] Suggest in search - way of doing with MySQL?

[David Pashley]

On Oct 02, 2008 at 15:22, Mark Ng praised the llamas by saying:
> Oh, one extra bonus - mySQL full text searching algorithms can
> sometimes be quite slow (depending on the search).  If you're working
> on a large (traffic wise) site, externalising the search into Lucene
> is 1) faster and 2) means you can take the weight of search away from
> the DB (which is the hardest thing to parallellize.)
> 
You should watch out for potential problems scaling lucene if you have
large amounts of data. Because it uses large index files, it can be hard
to add extra hardware to take over load. Of course, you may never get
into that situation.

-- 
David Pashley
david at davidpashley.com
Nihil curo de ista tua stulta superstitione.