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

In article <kRGsIAAGarw0EwdE_at_smooth1.demon.co.uk>, David Williams <djw_at_smooth1.demon.co.uk> wrote:
>In article <34C25418.B7525596_at_thunderstone.com.removethis>, THUNDERSTONE
><bart_at_thunderstone.com.removethis> writes
>>analysis to make it work.
>>
>>We've done databases in the size range you describe with our Texis
>>RDBMS, but the
>>key issues were more related to the scope of the queries and how long
>>they would
>>take. The disk managment and backup problems are a big pain at this size
>>too.
>
> Has anyone planned a restore of a database of this size? i.e. what
> happens if BOTH disks in what is assume would be mirrored get
> corrupted. How long would a full restore take? Has the disk layout
> been planned to minimize the downtime in the case of full restores?
> How long do you think it would take?
>
>>

The Rdb database I referred to in an earlier post used multiple standby databases continuously updated. Since most of the transactional records were stuff like $3 pay-per-view, if they lost a couple of records being transmitted during a huge catastrophe, that would be the least of their problems! But they paid their money, and got "almost instantaneous" switch over.

>>Bart Richards
>>Thunderstone
>
>--
>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

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!