No I mean e.g.
row 1 = 500 bytes,
row 2 = 600 bytes
row 3 = 80 bytes
row 4 = 300 bytes
etc.
Like the info that DBSTAT gives, but per row, not per page. This doesn't need
to be performant - it's for usage analysis during development time.
- Deon
-----Original Message-----
From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On Behalf Of
Simon Slavin
Sent: Wednesday, January 22, 2020 5:24 PM
To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
Subject: Re: [sqlite] Row length in SQLITE
On 22 Jan 2020, at 11:44pm, Deon Brewis <de...@outlook.com> wrote:
> Is there any way to get the length of rows in a table / index in sqlite?
Do you mean the count of rows in a table / index ?
SELECT count(*) FROM MyTable
There's no easy fast way to do this because SQLite doesn't keep that number
handy anywhere. It stores the entries in a tree and it would have to manually
count the leaves of the tree.
----
Or do you mean the count of columns in a table / index ?
SELECT * FROM MyTable LIMIT 1
and count the number of columns returned. Or in C
sqlite3_column_count()
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
