> 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
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
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
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
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
://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
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
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
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.
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
10 matches
Mail list logo