Re: [sqlite] How much a table takes (will this query always work)

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

Re: [sqlite] How much a table takes (will this query always work)

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

Re: [sqlite] How much a table takes (will this query always work)

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

Re: [sqlite] How much a table takes (will this query always work)

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

Re: [sqlite] How much a table takes (will this query always work)

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

[sqlite] How much a table takes (will this query always work)

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