[Fwd: [PyIndexer] Thoughts on MySQL Implementation]

[Chris W. <ch...@ni...>]

Dammit, reply-all :-)

Chris Withers wrote:
> 
> Marcus Collins wrote:
> >
> > I reckon MySQL can do it pretty efficiently given a set of ids, but
> > doing such processing as coalescing duplicates, etc., on the app side
> > would likely be faster than letting the MySQL query parser and optimiser
> > do it for you. That said, it would be only a matter of ms improvement;
> > the main benefit of app-side processing is in eliminating joins.
> 
> In that case, shall we try and keep it on the SQL side? ;-)
> 
> > > http://www.mysql.org/documentation/mysql/bychapter/manual_Reference.html#Fulltext_Search
> >
> > AFAIK, it doesn't do phrase matching. Their relevance calculation looks
> > very interesting, though.
> 
> Oooo, I'll have to take a look :-)
> (Although relevence ranking is pretty low on the list right now...)
> 
> cheers,
> 
> Chris