Thanks Clemens. From: Clemens Ladisch<mailto:[email protected]> Sent: 20 May 2017 09:11 To: [email protected]<mailto:[email protected]> Subject: Re: [sqlite] Index storage space
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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
