Largest DB Size in Production Usage

Largest DB Size in Production Usage

Post by mrichar.. » Thu, 06 May 1993 12:43:03

Hello to all,

WHO has the biggest baddest database out there in net-land?????

I'm currently involved in a project which may need to manage 100GB of data in
the next year or so.  I am unaware of any Unix-based site with a single DB
approaching this magnitude.  If anyone out there has 20GB or more (DB size,
not data size) in a production environment, could you please reply?  I'll
summarize for the net, so please indicate whether this is fine, or if you
would rather just correspond for info sharing purposes.

I realize that we may find all sorts of creative ways of partitioning the
data into multiple sites and/or DBs, but I'd like to know the tested limits
and issues within the context of a single DB for now.

Marv Richardson
SHL Systemhouse Inc.


1. Sybase/Oracle table size limitation / Largest production database

Is there anyone out there that has implemented a Sybase/Oracle table within a
database instance that is greater than 1 million rows? How large was it
and what platform were you using?

I have been told by knowledgable DBAs that both Oracle and Sybase performance
goes down the toilet after about 1 million rows due to the index
mechanism. This may apply to insert, delete, update and/or read.

Has anyone done benchmarks to this effect, i.e. response time for each
type of operation vs. size vs. number of database clients?

Robert Lesieur
Southwestern Bell

2. UK - M4 Corridor - Unix/Sql Operations Analyst

3. Large difference between backup size and db size

4. Perfomance monitoring SQL Server 7.0

5. Large-DB tricks (was Re: Best DB for large # of records)

6. Paradox 7 Can I make Executable Files?

7. Transaction log size larger than DB

8. HTML and SQLserver

9. DTS->Access, large DB size

10. Large Size MSSQL DB Backup

11. Large Block Size DB's

12. Largest DB in Syabse and Oracle - Startup size

13. Largest db size ( Gb )?