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/viewsSmall 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