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?
# .schema for TABLE builds
CREATE TABLE IF NOT EXISTS
builds(id INTEGER PRIMARY KEY,
c VARCHAR(50),
ts INTEGER,
tr VARCHAR(12),
f VARCHAR(200),
CONSTRAINT uc_rec UNIQUE(c, ts, tr, f))
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
