1. Beatrix Willius
  2. Valentina Database ADK
  3. Montag, November 21 2022, 10:30 AM
  4.  Abonnieren via E-Mail
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.
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
get property size of database
get property size of table t1
get property size of field t1.f1
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
Perfect!
Kommentar
There are no comments made yet.
  • Seite :
  • 1


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories