Re: LARGE Databases
Date: 14 Feb 1995 20:32:30 -0500
Message-ID: <3hrlje$nqu_at_newsbf02.news.aol.com>
> I have seen several posting of 10GIG to 50 GIG databases. My question
> is as follows.
> 1. Are these one table with 10 to 50 GIG, or a bunch of small tables
that
> total up to 10 to 50 GIG?
> 2. If it is one table, and you have to rebuild an index, do you close
> your business for a week, or what?
I have worked on one system where the total size was 135 GB and the largest table was 17 GB. When you get a system of this size, having a large multi-processor such as a Sequent, Sun ,etc. is really helpful (do not try this on a 386 running SCO). As I remember, the index rebuilds might take several hours on the really big tables, but since we had other processors and the large tables were not the summary tables used by decision support, it was not that big a problem. Hope this helps. Received on Wed Feb 15 1995 - 02:32:30 CET