Re: [sqlite] .db file size is not changing
I did, but the schema is about 4 times smaller than the DB file; also the SQL script should be more comprimable than the db file. This is obvious, because the db file also contain the SQL schema queries, so it must be larger than the only SQLite schema :) Paolo I think you have to do some VACUUM'ing in order to shrink the database. --Keith -Original Message- From: Paolo Vernazza [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 9:56 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] .db file size is not changing Unnikrishnan Nair wrote: 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 I think that it is better let your program create the DB structure from a sql schema script. Usually it is smaller than the corresponding DB.. sqlite data.db .schema > schema.sql Paolo
RE: [sqlite] .db file size is not changing
I think you have to do some VACUUM'ing in order to shrink the database. --Keith -Original Message- From: Paolo Vernazza [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 9:56 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] .db file size is not changing Unnikrishnan Nair wrote: >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 > > I think that it is better let your program create the DB structure from a sql schema script. Usually it is smaller than the corresponding DB.. sqlite data.db .schema > schema.sql Paolo
Re: [sqlite] .db file size is not changing
I am using sqlite for .Net dll for my programs. Do I have to change the dll if I change the sqlite from 2.8.0 to 2.8.15? --- Will Leshner <[EMAIL PROTECTED]> wrote: > Unnikrishnan Nair wrote: > > > I am using 2.8.0 > > You might want to give 2.8.15 a try because I do > think there was a VACUUM bug fixed recently. > __ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail
Re: [sqlite] .db file size is not changing
Unnikrishnan Nair wrote: I am using 2.8.0 You might want to give 2.8.15 a try because I do think there was a VACUUM bug fixed recently.
Re: [sqlite] .db file size is not changing
I am using 2.8.0 --- Will Leshner <[EMAIL PROTECTED]> wrote: > Unnikrishnan Nair wrote: > > > 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? > > I've run into this myself. It's as if VACUUM > decideds, for some reason, it can't do its job and > bails. But I seem to recall a recent checkin about > VACUUM. What version of SQLite are you using? > __ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail
Re: [sqlite] .db file size is not changing
Unnikrishnan Nair wrote: 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: You can always do a dump and reimport the db. John LeSueur
Re: [sqlite] .db file size is not changing
Unnikrishnan Nair wrote: 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? I've run into this myself. It's as if VACUUM decideds, for some reason, it can't do its job and bails. But I seem to recall a recent checkin about VACUUM. What version of SQLite are you using?
RE: [sqlite] .db file size is not changing
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
Re: [sqlite] .db file size is not changing
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 >
Re: [sqlite] .db file size is not changing
On Aug 17, 2004, at 7:56 AM, Unnikrishnan Nair wrote: How can I reduce the size or is it possible at all? Check out VACUUM in the documentation.
RE: [sqlite] .db file size is not changing
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