Use VACUUM..... tezo.
----- Original Message ----- From: "Unnikrishnan Nair" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, August 17, 2004 7:56 AM 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 >
