Re: Database Size Help Please

[Jose Saiz]

What I meant was!, What is the right Database Size for a 1.2 Millions Rows of data in one single table with with eight columns

Explain:

Table Inventory (Contains 1.2 Millions rows of data)
1 = StockID (Int())
2 = Title (Varchar(30)
3 = Genre (Varchar(30)
4 = Artist (Varchar(30)
5 = Formatype (Varchar(4)
6 = QtyOh (Int())
7 = Price (Float()
8 = VendorID (Varchar(10)

My Hosting only giving me 25mb for my MySQL database size.
I wonder if this is enough size for database with such a high volume of data
plus 5 more tables that will grow gradually.
Such as Customer Table, Transaction Table, Shipping Information Table, PO Table, Vendor_Supplier Table.

Future Analysis of Datas Collection
Supplier Table might get 15 Rows (Vendors Max)
Customer Table might get 1000 Rows within 5 years of business
Transaction Table might get over 100K rows within 5 years of business
Shipping Table might get over 100K rows within 5 years of business
PO Table might get over 30K rows within 5 years of business
Inventory Table might grow more than 1.2M based on new Titles throught out the years.

and I wonder if 25mb is enough for such data collection mentioned above.


Hope this is a good explanation and straight question.