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
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
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
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.
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
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
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
CTED]> wrote:
>
> > Unni,
> >
> > Try using the VACUUM command:
> >
> > http://sqlite.org/lang.html#vacuum
> >
> > Steve
> >
> > -Original Message-
> > From: Unnikrishnan Nair [mailto:[EMAIL PROTECTED]
>
> >
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
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.
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
11 matches
Mail list logo