On Wed, Jan 20, 2010 at 1:54 PM, Pavel Ivanov <paiva...@gmail.com> wrote: >> Why the difference in search time between searching individually and >> searching together? > > Apparently SQLite is not smart enough to optimize the search for both > min and max to make double entrance to the index - first from the > beginning, then from the end. It does search through the full index > instead which is not much better than search through the full table > (as it does without the index). But when searched separately SQLite > understands that it can pick up just first or just last entry from the > index.
Fair enough. Thanks. - Robert _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users