Simon - instead of using vacuum, it's much faster to create a new database from the old one, then rename it. It's easy to do this in Python using iterdump(), or you can connect to the new (empty) database, do your create table statements, attach the old database as olddb, then do:
insert into table1 select * from olddb.table1; insert into table2 select 8 from olddb.table2; This also lets you do the create table stmts w/o indexes, and add the indexes after the inserts. Not sure if that is faster or not for your data. Good luck! Jim -- HashBackup: easy onsite and offsite Unix backup http://www.hashbackup.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users