Unni, Try using the VACUUM command:
http://sqlite.org/lang.html#vacuum Steve -----Original Message----- From: Unnikrishnan Nair [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 17, 2004 3:57 PM To: [EMAIL PROTECTED] Subject: [sqlite] .db file size is not changing Hi all, I have a sqlite database. I had thousands of rows in it. I did a test with the database and everything was good. So before I ship it to production, I went to the database and I did drop all the index and 'deleted' all the rows from the table. I thought the size of the database will come down so that I can ship the model database for production. But the size didn't change. How can I reduce the size or is it possible at all? Thanks. Unni __________________________________ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail
