Good comments. And of course, each to his own. But, I wonder just how many database servers host VLS (very large scale) databases? I imagine the vast majority are much smaller.
Getting into databases that large, brings one into the arena of fiber channel connections, and other technology to increase speed and processing power. (Thinking of the terradata.microsoft.com deal) Then again, queries that are sloppily written can also place loads on a system that will bottleneck the data retrieval process on any system, regardless of configuration, right? > > Date: Mon, 15 Jul 2002 10:33:57 +0200 > From: Jochem van Dieten <[EMAIL PROTECTED]> > Subject: Re: The drive wars - was hardware question. > Message-ID: <[EMAIL PROTECTED]> > > samcfug wrote: > > The arguments of SCSI vs. IDE ATA 100 are like a religion, similar to > > Windows vs. *nix. > > > > The dual processor, and all that RAM will out perform your network > > connection by a large margin. Therefore the drive(s) will have redundant > > capacity and ability. > > He hasn't told us what network connection he has yet. > > > > As for performance - there will not be a noticeable difference. > > Not always. If you do a SELECT * FROM table WHERE categoryID = 7 on a 20 > GB table and the query-tree is an indexscan that gets 2000 different > blocks from all over the harddisk you will notice the difference. > > > > My own experience with IDE drives is that they will either fail within 30 > > days or so or last as long as 5 years. > > I have never had a dead SCSI disk (that I didn't shortcut with 220V > myself). And 2 dead IDE disks so far this year. > > > > There are, of course server owners with SCSI arrays, and server owners with > > IDE arrays. Each can be expected to swear by their own setup. > > I swear by my setup for my *problem*. I still don't know enough about > Bud's load pattern to say something except for the obligatory remarks > about seek time and serialization that might not even be relevant for > his case. > > Jochem > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
