Hey Friends,

I recently came across a question which asks to approximate the data volume of a table which contains 10 Million records.

Any idea on how to do it?

Thanking You In Advance.

Recommended Answers

It depends on the storage engine, field types, encoding. Check this link: http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html

bye!

Jump to Post

All 4 Replies

thanks cereal for ur post.

My Last Question:

Is there any formula to calculate data volumes?

If you check the comments at the end of the page, of the posted link, you will find some perl scripts to do such calculations ;)

Thanks cereal, Ur a genius ;-)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.