[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]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic