Jose Saiz wrote:
> 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)
You could compute the storage requirement per row using
http://dev.mysql.com/doc/mysql/en/storage-requirements.html
Then multiply the needed storage by the number of rows.
Indexes also use disk storage. And suitable indexes are important for performance.
You probably would get a better estimation by running (for tests) a MySQL/Linux/PHP/Apache on your PC, and measuring precisely there the real occupation.
> My Hosting only giving me 25mb for my MySQL database size.
25Mb is not a lot for 1.2Mrows. It means 20 bytes per row. This is really small.
Did you consider buying more storage from your hosting company, or changing your hosting company to another one? In France, there are several hosting companies selling nearly a gigabyte of disk storage, and Web hosting, for less than about 100 euros per year. Hosting prices are a lot cheaper than inhouse software development costs!
--
Basile STARYNKEVITCH ::::
http://starynkevitch.net/Basile/