Thread: Sizes
I am new to databases and would like to gain some idea of the sizes of a typical singal database.
For instance what are the number of schemas, tables and views that would constitute a databse considered to be small, medium or large?
Bob Pawley
On Fri, 2005-07-01 at 07:50 -0700, Bob Pawley wrote: > what are the number of schemas, tables and views that would > constitute a databse considered to be small, medium or large? Totally subjective opinion: Small database: few dozen tables/views Medium database: 100 tables/views Large database: 1000 tables/views Small table: few dozen rows Medium table: few thousand rows Large table: millions of rows
Matt Miller wrote: > On Fri, 2005-07-01 at 07:50 -0700, Bob Pawley wrote: > >>what are the number of schemas, tables and views that would >>constitute a databse considered to be small, medium or large? > > > Totally subjective opinion: > > Small database: few dozen tables/views > Medium database: 100 tables/views > Large database: 1000 tables/views > > Small table: few dozen rows > Medium table: few thousand rows > Large table: millions of rows Another completely subjective opinion: when people talk about large or very large databases (VLDB) they usually refer to the amount of data, not the number of tables or views. For example, a database that occupied 50 GB would be considered large even it had a dozen tables (most likely with a few of those having millions of rows). Conversely, a database with 500 tables but occupying only 1/2 GB would likely be considered small or medium. Joe