From the documentation “A record might have fewer values than the number of columns in the corresponding table. This can happen, for example, after an ALTER TABLE ... ADD COLUMN SQL statement has increased the number of columns in the table schema without modifying preexisting rows in the table. Missing values at the end of the record are filled in using the default value for the corresponding columns defined in the table schema.”
Suppose you have a table with say 5 columns that are almost always the default value (probably zero or null). Does the above suggest you should make them the last 5 columns in the table as the last n columns that are the default value won’t take up space? Or does this state just exist after ADD COLUMN but any rows added thereafter use the space? *Assume the 5 columns are little used so it doesn’t matter that they are the last named columns. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
