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