Embedded full-text search
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.
More information about the PLUG