Well, I deleted the rows, droped the index and did a vacuum on the table and nothing happen. I still have the file size as 198M. Is there anything else I am missing? --- Unnikrishnan Nair <[EMAIL PROTECTED]> wrote:
> Thanks all. > --- "Drew, Stephen" <[EMAIL PROTECTED]> wrote: > > > 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 > > > > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail is new and improved - Check it out! > http://promotions.yahoo.com/new_mail > __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - 100MB free storage! http://promotions.yahoo.com/new_mail
