Embedded full-text search

Eric Jacobs eric at chomp.us
Wed Jun 6 11:42:52 MDT 2012

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. 

Eric Jacobs

On Wednesday, June 6, 2012 at 10:12 AM, AJ ONeal wrote:

> Let's say I want to run full-text searches on 1,000,000 <256 character
> strings on a raspberry pi. What would I use?
> On my macbook a LIKE query with sqlite takes about 30 seconds... which is a
> LONG time.
> AJ ONeal
> /*
> PLUG: http://plug.org, #utah on irc.freenode.net (http://irc.freenode.net)
> Unsubscribe: http://plug.org/mailman/options/plug
> Don't fear the penguin.
> */

More information about the PLUG mailing list