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 <zar...@gmail.com> 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 > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users On Mon, Jul 30, 2018 at 4:46 PM, Eric Grange <zar...@gmail.com> 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 > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- D Burgess _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
