On 10 Nov 2011, at 10:41pm, Fabian wrote:
> Is there some trick to force VACUUM-like output when building the
> database, and avoid to build it twice?
CREATE your TABLES.
BEGIN TRANSACTION.
INSERT your data.
END TRANSACTION.
CREATE your INDEXes.
This should get you the fastest process, and the neatest indexes. But I think
that the indexes will still not be sorted in the same way as VACUUM does it.
Because the index has to be created in the order that the data is found.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
