1. Beatrix Willius
  2. Valentina Database ADK
  3. 月, 11月 21 2022, 10:30 AM
  4.  メールで購読
Is there a possibility to get the table size for a database? I can get the number of records for each table with SQL

select fld_name, fld_record_count from (show tables) where fld_kind = 0

But I don't see a way to get the size of all tables.

For my email archiving app the user end up with large databases. Because I save the raw data of the email the database usually is larger than the raw data. Now I have a user who made a 120 GB database out of 8 GB of emails. So I want to know what is in his tables. For now I've asked him to check in Valentina Studio.
コメント
There are no comments made yet.
Ivan Smahin 承諾済みの回答
get property size of database
get property size of table t1
get property size of field t1.f1
コメント
There are no comments made yet.
Beatrix Willius 承諾済みの回答
Perfect!
コメント
There are no comments made yet.
  • ページ :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.