download sqlite3_analyzer from http://www2.sqlite.org/2018/sqlite-tools-linux-x86-3240000.zip
On Mon, Jul 30, 2018 at 4:46 PM, Eric Grange <[email protected]> wrote: > Hi, > > Is there a quick way (as in speed) to obtain the number of database blocks > (or kilobytes) allocated for each table and each index ? > > I have been using various manual approaches so far (from using length() to > vacuum and drops), but none of them are really fast > or can practical to automate. > > Eric > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users On Mon, Jul 30, 2018 at 4:46 PM, Eric Grange <[email protected]> wrote: > Hi, > > Is there a quick way (as in speed) to obtain the number of database blocks > (or kilobytes) allocated for each table and each index ? > > I have been using various manual approaches so far (from using length() to > vacuum and drops), but none of them are really fast > or can practical to automate. > > Eric > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- D Burgess _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
