I forgot that sqlite page_size is lost during a .dump.
The command should actually be:
(echo "PRAGMA page_size=8192;" ; sqlite3 your.db .dump) | sqlite3 new.db
This runs 4 times faster on my machine with a large database than the command
below
with a default page_size of 1024. Replace 8192 with the desired page size.
----- Original Message ----
I'd be curious to learn if the timings of VACUUM on this database are any
different
than the following:
sqlite3 your.db .dump | sqlite3 new.db
____________________________________________________________________________________
Sponsored Link
Don't quit your job - take classes online
www.Classesusa.com
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
