Log in

View Full Version : look out for the size



hosdank
08-12-2008, 02:58 AM
Hey, I was wondering if I have a database with 10,000 tables each have an average of 10 columns and 200 rows, each cell have about 5 characters, how much space will that take up? Thanks :)

Nile
08-12-2008, 03:08 AM
You'd have to check some way your self, it all depends on the data all of these hold. So we can't tell you right of the spot.

hosdank
08-12-2008, 03:10 AM
Thanks :) ... Actually how would I check?

Nile
08-12-2008, 03:26 AM
I think that there would only be one way to do it... If you don't know what it is, then lol. Haha, not trying to be mean. ;) I think you've gotta put it all in your self, or find out how much space each table, field, database individually it takes then multiply.

kuau
08-12-2008, 10:40 AM
I doubt this will help you much, but I had a database that had 121,000 records (in all tables combined) and it was about 11Mb.

I would shoot myself if I had to look after 10,000 tables haha. :) e