Re: [sqlite] delete rows but the database files still have the big size

Thanks a lot Paul! It worked. Thanks, JP - Original Message From: Paul Smith <[EMAIL PROTECTED]> To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Tuesday, April 15, 2008 1:34:14 AM Subject: Re: [sqlite] delete rows but the database files still have

Re: [sqlite] delete rows but the database files still have the big size

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. >

[sqlite] delete rows but the database files still have the big size

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