-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 05/31/2011 12:18 PM, Jan Hudec wrote: > - Is there any way to speed it up?
Another way (somewhat hinted at by Nico) is that you can create these tables in separate databases and use attach to bring them in. To drop a table you can just detach and then delete the database file (at a later point if necessary). If the new database is going to be the approximately the same size as the old one then you can overwrite the database header to cause the database to be empty but already the allocated size so the operating system won't have to go through a free then allocate cycle for the file blocks. This will also allow you to do hot swapping if that is important to you. You can build up the new tables/databases separately and then when ready to use them do a detach/attach which should be very quick. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk3l6IQACgkQmOOfHg372QRfTwCgqT0qnW9osxVGff9M1w5rDyKh ANIAoKr+cCCpkJRXnfIGmdglpGdWEEtZ =DDJh -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
