On 21 May 2011, at 8:38pm, romtek wrote: > I've just tested with a query I was working on with an SQLite management > tool and noticed that selecting all fields took at least *twice as long* as > selecting only two, and I don't have a huge number of columns (only 18). And > I am not sure if I was testing SQLite or this particular tool.
SQLite does some clever stuff that's hidden from you. For instance, if you're selecting only fields which are mentioned in the index it uses for the SELECT, it never bothers to read the data record at all, it takes the values straight out of the index. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
