Thanks a lot Paul! It worked.
Thanks,
JP
- Original Message
From: Paul Smith <[EMAIL PROTECTED]>
To: General Discussion of SQLite Database
Sent: Tuesday, April 15, 2008 1:34:14 AM
Subject: Re: [sqlite] delete rows but the database files still have the big size
Joanne Pham wrote
Joanne Pham wrote:
> Do I miss some commands here? I thought the database file size shoud get much
> smaller after the delete operation but it isn't.
> Can you please help to let me know how to get the database file szie smaller.
> I have tried "VACUUM" but the file's size didn't change.
>
VACU
Hi All,
I have used sqlite3 command to clean up ton of rows in the table by executing
the following command
sqlite3> delete from compressTable where appId > 10;
The command above has deleted ~ 99% of the table and now this table has ~ 100
rows but the database file size is the same as before the
3 matches
Mail list logo