Re: [sqlite] get the actual database size.

2008-05-31 Thread Aladdin Lampé
> From: [EMAIL PROTECTED] > Date: Fri, 30 May 2008 20:26:14 +0200 > Would sqlite3_analyzer work for you? > It produces both a human readable report as well as a table > definition and insert statements to feed to sqlite3 command > line tool. Where can we download the source of this tool

Re: [sqlite] get the actual database size.

2008-05-30 Thread Kees Nuyt
On Fri, 30 May 2008 09:18:39 -0700 (PDT), you wrote: >Hi , >I have two questions: >    1) Calucate the actual size of the database(NOT RUN VACUUM) - "Actual >database size" which won't include the space of deleted rows. >        To be more specific you calculate the database size by the

Re: [sqlite] get the actual database size.

2008-05-30 Thread Joanne Pham
don't run the "VACUUM" on the database.   Thanks, JP - Original Message From: Ronny Dierckx <[EMAIL PROTECTED]> To: [EMAIL PROTECTED]; General Discussion of SQLite Database <sqlite-users@sqlite.org> Sent: Friday, May 30, 2008 12:12:14 AM Subject: Re: [sqlite] get the act

Re: [sqlite] get the actual database size.

2008-05-30 Thread P Kishor
P Kishor <[EMAIL PROTECTED]> > To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > Sent: Thursday, May 29, 2008 5:40:23 PM > Subject: Re: [sqlite] get the actual database size. > > On 5/29/08, Joanne Pham <[EMAIL PROTECTED]> wrote: > > H

Re: [sqlite] get the actual database size.

2008-05-30 Thread Joanne Pham
lt;sqlite-users@sqlite.org> Sent: Thursday, May 29, 2008 5:40:23 PM Subject: Re: [sqlite] get the actual database size. On 5/29/08, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi All, >  I have the database which has a lot of insertion and deletion. >  Is there anyway that I can g

Re: [sqlite] get the actual database size.

2008-05-30 Thread Ronny Dierckx
://www.syntegro.be -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of P Kishor Sent: vrijdag 30 mei 2008 2:40 To: General Discussion of SQLite Database Subject: Re: [sqlite] get the actual database size. On 5/29/08, Joanne Pham <[EMAIL PROTECTED]> wrote

Re: [sqlite] get the actual database size.

2008-05-30 Thread Darren Duncan
P Kishor wrote: > On 5/29/08, Joanne Pham <[EMAIL PROTECTED]> wrote: >> Hi All, >> I have the database which has a lot of insertion and deletion. >> Is there anyway that I can get the actual database size without running >> VACUUM. > > Your question implies that VACUUM lets you "get the

Re: [sqlite] get the actual database size.

2008-05-30 Thread Mihai Limbasan
Joanne Pham wrote: Hi All, I have the database which has a lot of insertion and deletion. Is there anyway that I can get the actual database size without running VACUUM. Thanks, JP Hi, Joanne. I assume that by "actual database size" you mean "the size of the database file minus the size of

Re: [sqlite] get the actual database size.

2008-05-29 Thread P Kishor
On 5/29/08, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi All, > I have the database which has a lot of insertion and deletion. > Is there anyway that I can get the actual database size without running > VACUUM. Your question implies that VACUUM lets you "get the database size." No, it doesn't.

[sqlite] get the actual database size.

2008-05-29 Thread Joanne Pham
Hi All, I have the database which has a lot of insertion and deletion. Is there anyway that I can get the actual database size without running VACUUM. Thanks, JP ___ sqlite-users mailing list sqlite-users@sqlite.org