Re: Database performance and size

an416965_at_anon.penet.fi <an416965_at_anon.penet.fi> writes:  

>I've personally set up systems that do full table scans
>of 8 gig (50 million rows) in about 3 minutes. In this
>case the hardware was set up to read about 45 meg
>per second sustained. Of course if you throw a lot
>of memory at the problem, you can get even better
>performance!
>
 

would you please inform us as to your hardware configuration? i'm data warehousing on a sparc strage array - getting ok response time - but nothing like 45Mb/s!!! were you striping? RAID5?  

thanx,
douglas
dacummins_at_delphi.com
delphi consulting services, inc.
:-> Received on Wed Dec 27 1995 - 00:00:00 CET