On Fri, Jul 16, 2010 at 5:14 PM, Jim Wilcoxson wrote:
> >>
> > You mean, like this?
> >
> > pragma page_count
> > pragma page_size
> > size = page_count*page_size
> >
> >
> Doh. Nevermind. I see you said table, not database. :)
>
>
If I'm asked, the syntax PRAGMA
On Fri, Jul 16, 2010 at 4:52 PM, Jay A. Kreibich wrote:
>
> Check out sqlite3_analyzer. This is available in binary format only
> on the SQLite website. http://sqlite.org/download.html
>
>
Thanks, the tool is really great, but just wondering can the code used there
be part
On Fri, Jul 16, 2010 at 9:13 AM, Jim Wilcoxson wrote:
> On Fri, Jul 16, 2010 at 6:01 AM, Max Vlasov 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
On Fri, Jul 16, 2010 at 6:01 AM, Max Vlasov 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
On Fri, Jul 16, 2010 at 02:01:27PM +0400, Max Vlasov scratched on the wall:
> 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)
Check out sqlite3_analyzer. This is available in
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)
Recently I made a query that probably solves this, but it has some
limitations and there are still issues unsolved.
So, let's
6 matches
Mail list logo