Re: PUBLIC:Re: Has anyone developed applications with DB's over 100GB?

In article <34BDCD87.1EF3B279_at_ubs.com>, Eugen Nyffeler <eugen.nyffeler_at_ubs.com> writes
>Marc Jacobson wrote:
>>
>> I have never heard of a database so enormous. But I would think the only
>> common database that might be capable would be DB2.
>>
>
>Welcome to the world of Oracle.

  Or Informix, K_Mart has a 600Gb database. MCI has a 2 Terabyte   database. Informix has several sites >500Gb..

>I've worked with DB's in this size and larger on Oracle under Unix.
>One problemarea was the backup/restore of this DB's due to 7*24h
>availability , also sometimes the queries over tables with 30Million
>rows (and up), wrong joined or queries which coudn't use indexes.
>The most importend part is a sound DB design.
>
>if i'm right Oracle is also used on DB's in the tera byte area.
>
>rgds
>eugen
 

-- 
David Williams

Maintainer of the Informix FAQ
 Primary site (Beta Version)  http://www.smooth1.demon.co.uk
 Official site                http://www.iiug.org/techinfo/faq/faq_top.html

I see you standin', Standin' on your own, It's such a lonely place for you, For 
you to be If you need a shoulder, Or if you need a friend, I'll be here 
standing, Until the bitter end...
So don't chastise me Or think I, I mean you harm...
All I ever wanted Was for you To know that I care