Thanks to the reference to the sqlite_analyzer. That is very
interesting. (And the manual counting of bytes would also help me for my
question..)
The main question I have is how expensive will adding an fts4aux table be?
I noticed the report for a FTS table e.g. NOTES_FTS
only shows results f
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/04/2015 10:26 AM, Rael Bauer wrote:
> Is it possible to get the information of how many bytes a table is
> taking up in the database?
What is the underlying problem you are trying to solve with this
information? There may be alternate approach
On 2015/02/04 20:26, Rael Bauer wrote:
Hi,
Is it possible to get the information of how many bytes a table is taking up in
the database?
Not with API calls, but it is possible by running the SQLiteAnalyzer utility
afvailable from the same download pages as SQLite3 CLI etc.
http://www.sqlite
On 4 Feb 2015, at 6:49pm, Stephen Chrzanowski wrote:
> I can't be certain if a
> single page contains multiple types of data such as table AND index
> information.
In a SQLite file, each page is assigned to header information or to a specific
table or index. No mixed use.
However I agree wit
Wrong answer.
He's asking how many bytes a table takes up within the database. That
would depend on a whole lot of factors including what is stored, the number
of fields, etc.
Is there SQL code to get requested result?
Short answer, No. Not easily.
Long answer, a table isn't a certain number
On 4 February 2015 at 18:26, Rael Bauer wrote:
> Hi,
>
> Is it possible to get the information of how many bytes a table is taking up
> in the database?
For Windows, see http://www.sqlite.org/download.html#a10
There are other links for other operating systems
> Thanks
> Rael
Regards,
Simon
Hi,
Is it possible to get the information of how many bytes a table is
taking up in the database?
Thanks
Rael
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
7 matches
Mail list logo
