Re: [sqlite] constraint doubled database size

2010-11-09 Thread Igor Tandetnik
linux fan 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 en

[sqlite] constraint doubled database size

2010-11-09 Thread linux fan
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 buil