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
|
