rway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users On
>Behalf Of Deon Brewis
>Sent: Friday, 24 January, 2020 21:14
>To: SQLite mailing list
>Subject: Re: [sqlite] Row length in SQLITE
>
>No I mean e.g.
>
>row 1 = 50
;-Original Message-
>From: sqlite-users On
>Behalf Of Deon Brewis
>Sent: Friday, 24 January, 2020 21:14
>To: SQLite mailing list
>Subject: Re: [sqlite] Row length in SQLITE
>
>No I mean e.g.
>
>row 1 = 500 bytes,
>row 2 = 600 bytes
>row 3 = 80 bytes
>row
On Behalf Of
Simon Slavin
Sent: Wednesday, January 22, 2020 5:24 PM
To: SQLite mailing list
Subject: Re: [sqlite] Row length in SQLITE
On 22 Jan 2020, at 11:44pm, Deon Brewis wrote:
> Is there any way to get the length of rows in a table / index in sqlite?
Do you mean the count of r
On 22 Jan 2020, at 11:44pm, Deon Brewis 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
Is there any way to get the length of rows in a table / index in sqlite?
DBSTAT/sqlite3_analyzer --stats almost gives me the information I want, but
it's an aggregate sum & max per page - I need the data per row (cell).
- Deon
___
sqlite-users
5 matches
Mail list logo