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