On 5 Mar 2013, at 2:37pm, Richard Hipp <d...@sqlite.org> wrote: > On Tue, Mar 5, 2013 at 9:26 AM, Simon Slavin <slav...@bigfraud.org> wrote: > >> I've seen programs written by people who always do 'SELECT *" even when >> they want just a couple of fields. That's going to be a lot more expensive >> under SQLite4. Maybe it'll teach them to be better programmers. > > Why will it be any more expensive under SQLite4 than it is under SQLite3?
I probably misunderstood. My impression was that under SQLite3, all the fields of one row were stored 'near' one-another, so getting the value of one of them would read the others into cache, whereas under SQLite4 this wasn't true. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users