xTom Byars wrote: > I’m aware that a column value of 1 will use less bytes in an sqlite database > than a value of 4875874568437607. Does this also apply to indexes?
Yes; tables and indexes use the same record format <http://www.sqlite.org/fileformat2.html#record_format> in which the integers 0 and 1 have a content size of 0 bytes. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users