Embedded full-text search

Steve Meyers steve-plug at spwiz.com
Wed Jun 6 12:01:08 MDT 2012


On 6/6/12 11:42 AM, Eric Jacobs wrote:
> Definitely make sure that you're using an index on your table. That
> will probably speed up your queries quite a bit. I have no idea what
> you would index on this table though.

Normal indexes do nothing for full-text searches.  You need a full-text 
index of some sort.  MySQL has support for those, but it's not really 
all that great.  There are much better full-text search engines out 
there, like Lucene or Sphinx.  I don't know how well either would do on 
a Raspberry Pi.

Steve


More information about the PLUG mailing list