linux fan <linuxscra...@gmail.com> wrote: > I rebuilt a table after adding a multi-column constraint > and the database disk file size is more than double > compared to the size that it was without the constraint. > > Is this the expected behavior, or have I done something wrong?
It's expected. An index is created to enforce the constraint, containing all the same fields as the table itself. You effectively have all the data repeated twice. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users