Embedded full-text search
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.
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