Re: [sqlite] Row length in SQLITE

2020-01-27 Thread Keith Medcalf
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

Re: [sqlite] Row length in SQLITE

2020-01-27 Thread Keith Medcalf
;-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

Re: [sqlite] Row length in SQLITE

2020-01-24 Thread Deon Brewis
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

Re: [sqlite] Row length in SQLITE

2020-01-22 Thread Simon Slavin
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

[sqlite] Row length in SQLITE

2020-01-22 Thread Deon Brewis
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