Re: [sqlite] .db file size is not changing

2004-08-26 Thread Paolo Vernazza
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

RE: [sqlite] .db file size is not changing

2004-08-26 Thread Keith Herold
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

Re: [sqlite] .db file size is not changing

2004-08-17 Thread Unnikrishnan Nair
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

Re: [sqlite] .db file size is not changing

2004-08-17 Thread Will Leshner
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

2004-08-17 Thread Unnikrishnan Nair
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

Re: [sqlite] .db file size is not changing

2004-08-17 Thread John LeSueur
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

Re: [sqlite] .db file size is not changing

2004-08-17 Thread Will Leshner
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

RE: [sqlite] .db file size is not changing

2004-08-17 Thread Unnikrishnan Nair
CTED]> wrote: > > > Unni, > > > > Try using the VACUUM command: > > > > http://sqlite.org/lang.html#vacuum > > > > Steve > > > > -Original Message- > > From: Unnikrishnan Nair [mailto:[EMAIL PROTECTED] > > >

Re: [sqlite] .db file size is not changing

2004-08-17 Thread tezozomoc
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 t

Re: [sqlite] .db file size is not changing

2004-08-17 Thread Will Leshner
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

2004-08-17 Thread Drew, Stephen
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