Very Computer

Hi,
        We are scoping/designing a system's integration project and need numbers
that show how Unix performs with a LARGE database. Information on Teradata would
also be helpful. The current debate is where to put the database: on the Unix
box or on the Mainframe? Obviously a high-end (mainframe equivalent) Unix
machine must be involved. I'm interested in benchmarks for large databases - in
the range of 10's of gigabytes. If you have worked with any databases of this
size on Unix and could provide any of the following, it would be greatly
appreciated:

Platform:
Database Size:
Performance:
Aids/Tools to tune:

Any other information would be helpful as well. ADVthanksANCE.

                        Kevin Dombroski

--
================================================================================
Kevin M. Dombroski                  | "One good thing about music,
Cambridge Technology Partners       |  When it hits, you feel no pain...."
================================================================================

Quote:

> Hi,
>    We are scoping/designing a system's integration project and need numbers
> that show how Unix performs with a LARGE database. Information on Teradata would
> also be helpful. The current debate is where to put the database: on the Unix
> box or on the Mainframe? Obviously a high-end (mainframe equivalent) Unix
> machine must be involved. I'm interested in benchmarks for large databases - in
> the range of 10's of gigabytes. If you have worked with any databases of this
> size on Unix and could provide any of the following, it would be greatly
> appreciated:

> Platform:
> Database Size:
> Performance:
> Aids/Tools to tune:

I would also be interested in this information.  We use informix, and soon
will have a customer coming online with a 60 gig database.  I cringe to
think of how long it will take to maintain this puppy (ie. emergency table
unloads/dbexport type stuff).

We have seen firsthand that creating and dropping indicies on huge tables
(>1 million or so rows) causes problems.  I'm sure there are more gotchas.

--
  Naomi Walker  (aka N7FSA)        Anasazi Inc.  Phoenix, Arizona

  Imagine the Universe Beautiful, Just, and Perfect. (Messiahs Handbook)