> > Primary key provides the index for the search. Without it, SQLite would do > full table scan. Use EXPLAIN QUERY PLAN to convince yourself.
I could use a binary search, but I worry about having a ten MB array in memory on a mobile device, though it should work fine. >Uhh, sounds like a search function of a text editor or a simple routine >you could write (or find) in your development language. I can't see >the magic of using sqlite. The magic is that it's easy and it works. The problem is solved. But, in this case, all I need is the index. Maybe I'll try a binary search, or something else along those lines. > > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
