Thread: Sizes

Sizes

From
Bob Pawley
Date:
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

Re: Sizes

From
Matt Miller
Date:
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

Re: Sizes

From
Joe
Date:
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