Hi, Barry,
Regarding: "Could you please explain me why the indexing is so important?
(for
future reference)."
If you're asking just in *general* why indexes can speed up searching a
database table, you might want to look at most any sql tutorial, or
resources such as:
http://en.wikipedia.org/wiki/Index_%28database%29
You might then want to look at the sqlite document for the
EXPLAIN QUERY PLAN
If I've misunderstood your question and you're asking something much more
specific, I apologize in advance.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
