[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] How much a table takes (will this query always work)
From:       Jim Wilcoxson <prirun () gmail ! com>
Date:       2010-07-16 13:14:10
Message-ID: AANLkTiljI08TJx7K4cU8ee0VnC0ouxGlxFnx2nmcbeXM () mail ! gmail ! com
[Download RAW message or body]

On Fri, Jul 16, 2010 at 9:13 AM, Jim Wilcoxson <prirun@gmail.com> wrote:

> On Fri, Jul 16, 2010 at 6:01 AM, Max Vlasov <max.vlasov@gmail.com> wrote:
>
>> Hi,
>>
>> always wanted to have a possibility to calculate how much a table
>> occupies.
>> As long as I see from the archive, there's no out-of-the-box solution
>> (CMIIW)
>>
>>
> You mean, like this?
>
> pragma page_count
> pragma page_size
> size = page_count*page_size
>
>
Doh.  Nevermind.  I see you said table, not database. :)

JIm
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]