Re: Need benchmarks for LARGE db's on Unix (10's of Gig)

> > 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 naomi%anasaz.UUCP@asuvax.eas.asu.edu Imagine the Universe Beautiful, Just, and Perfect. (Messiahs Handbook)