Space is all you need! How to determine space on server?

[Web_Decisions]

Hi,

Having structured the database structure? How much space will I need to determine database size of this database? We know the size of the record. We know the number of fields? Multiply by the number of staff? So what formula (multiplican formula) will I need to do on this prediction of database size?

Fields x 12

Type length ?? - What value will this be as the data types are mixed here, like date, like text?

Records - n

Database size = fields x record length x n

Is this the right formula?

[Rob Hecker2]

The size of your database?

It's more complicated than simply fields x record length x n

But why is this even a concern for you?

[Web_Decisions]

Hi,

As it hosted and buying host web space has to be taken into consideration. It is a concern to me. I am aware how many records I am going to put onto the server. Hence, it is call capacity planning! It is part of the project plan.

[Rob Hecker2]

I don't know if you are thinking of shared hosting, VPS, or dedicated servers, but regardless, I would not say. . . "space is all you need!"

In fact, on any kind of hosting account, I think bandwith, processing muscle, and number of allowed mysql processes would probably all be issues before storage size.