> On Jul 31, 2019, at 5:02 AM, Hick Gunter <[email protected]> wrote: > > SQLite stores rows in a compressed format that requires decoding. To access > the nth field, all the fields that come before it need to be decoded.
My understanding is that it’s just a matter of a byte-count before each field. So getting to the n’th field just requires n-1 memory reads and pointer additions, a handful of machine instructions. If so, that won’t measurably affect performance. The increased size of the record does make a big difference, though, for the reasons discussed earlier. —Jens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
