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 deletion.
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.
Thanks,
JL
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
