Geek asks and answers

How many records / tables can I get in a 1 GB database?

I think about buying a shared hosting provider, and then I offer a 1 GB MSSQL database with the package.

It may not be an exact science , but how many records / tables can be stored in a 1 GB database? I will save pure text (value: nvarchar, varchar, int, bool), not binary / blobs.

For this question, imagine about 20 tables, 9 fields each. Not empty for each field.

Is there a way to evaluate and design how long this will hold me back before I need to upgrade to a more expensive package?

+5
source share
3 answers

, , " " " / " , MSSQL 1 , . :

  • , ?
  • ?
  • ?

() , < 400 000 > 3 500 000, , . , , ( ) /, , .

+7

, E.J. - " ?"

, , .

0

This is a very good question. It depends on many things, the number of tables, rows, what is in them, etc.

edit: ok, you did the editing. "For this question, imagine about 20 tables with 9 fields each. Not empty for each field." 1 database, 20 tables, 9 fields each, we say varchar (16).

I would say about 300,000 (300K) rows, but it depends on the type of database structure (innoDB or other types)

0
source

More articles:


All Articles