Database Development

Question

Hello friends please how do I estimate column size and database size for a school portal and where do you recommend that I should host it?

Nilesh Shah · Answer

You did not mention what DB product you want to use so I will assume MS SQL Server. You can host it on MS Azure quick and easy. Many other cloud services provider like AWS also offer it. for estimation there is no particular tool you have to design by per table basis then you can derive size per row per table and estimate no. of possible rows then sum all tables but its hard to exactly derive your DB size until your application is in actual use

Cyril Ejike · Answer

Thank you all for your kind answers. The database tool that I am using is Microsoft SQL Server.

Manikandan Murugesan · Answer

Refer the Following Link : http://www.databasejournal.com/features/mysql/calculating-mysql-database-table-and-column-sizes.html