On Mar 14, 2010, at 7:19 PM, Matthew L. Creech wrote:

> Hi,
> I have a SQLite database with one large table, and I'd like to shrink
> the size of that table to free up space in the filesystem.
> I'm finding that it needs a full 100 MB for the journal, even
> though once the VACUUM succeeds the resulting DB is only 50 MB.
> Any tips are appreciated.  Thanks!

PRAGMA journal_mode=OFF;

Be warned, though, that if you session crashes or you lose power, your  
database will go corrupt if there is no journal.

D. Richard Hipp

sqlite-users mailing list

Reply via email to