Total number of bytes used per record?
SELECT LENGTH(col1)+LENGTH(col2)+LENGTH(col3)+... FROM table
Should deliver reliable sizes at least for text based data types such as VARCHAR and TEXT.
I was creating a new table with about 20 columns of all different data types which I was trying to optimise with regard to the storage size for each record. It's the first time I have used a database so am not totally clear on the exactly storage size of each data type. So I thought it would be useful (to me at least) to have an indication of the total storage required for the records in the table (as you add new columns). It would help make sure the records weren't taking up more space than they need to.
Is it clear now what I mean?
If you could provide a real life example of those optimizations you have in mind, we could probably help you point out the precise misconception.
however, i must side with kalvaro; size-optimizing db record structures by hand in the age of terabyte drives seems to me a strangely retro kind of hobby.
one alternative adhoc strategy that i have used myself would be:
1) make fields quite large;
2) wait until table contains a sizeable amount of data;
3) statistically analyze field usage, and optionally shrink some fields accordingly.
I've noticed that if you want the size of a certain result set you can "export the grid". The Export dialog will inform you of the size of the result. You can see the size of the
Selection or the
Attached a Screenshot to this post to illustrate. See the
Row Selection section.
Please login to leave a reply, or register at first.