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
