On 2015/02/04 20:26, Rael Bauer wrote:
Hi,
Is it possible to get the information of how many bytes a table is taking up in
the database?
Not with API calls, but it is possible by running the SQLiteAnalyzer utility
afvailable from the same download pages as SQLite3 CLI etc.
http://www.sqlite.org/download.html
In the output which the analyzer produces, you can find the space taken up by any table or index, also the total pages ofr tables
and the bytes payload (which is the actual amount of data, I believe what you are looking for?) among a myriad of other data
properties and measurements.
Also, you can load the output as a script which would add a table to your database storing all this info - but it is of course
only updated once the analyzer is run again.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
