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

Reply via email to