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 /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
