Re: Row length in SQLITE

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 <[email protected]> On Behalf Of Simon Slavin
Sent: Wednesday, January 22, 2020 5:24 PM
To: SQLite mailing list <[email protected]>
Subject: Re: [sqlite] Row length in SQLITE

On 22 Jan 2020, at 11:44pm, Deon Brewis <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users