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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to