Re: Best Search Algorithm for Millions of record

Stut wrote:

On 6 Oct 2008, at 07:17, Hemant Patel wrote:

My question is Whether I should go for Full Text Based search or Database Search...?And is there algorithm in php which can help me in this case...?

I can fully recommend Sphinx Search: http://sphinxsearch.com/. It's not as easy to implement as a full-text index but the power and flexibility you get are well worth the effort. -Stut

As a complete alternative apache solr is rather(very) good: http://lucene.apache.org/solr/features.html Regards -- nathan ( nathan@kraya.co.uk ) { Senior Web Developer php + java + flex + xmpp + xml + ecmascript web development edinburgh | http://kraya.co.uk/ }