Thanks for all of the great info. I've taken a look at some of the links provided, and it's all been very helpful. Interestingly, one point was made that really struck a note with me - quiet. I'm doing research on quiet fans and would really appreciate any thoughts anyone may have on that point. I'm afraid this is gonna be a beast no matter what I do.
Yes - I'm ashamed to admit it, but the last box I built myself for myself was 6 years ago. [Fractured English] The last PC I bought was about 3 years ago and is a Dell XPS T500 that I got at the same time as my brother was buying his first system so I could support him [/Fractured English]. It's come in handy as I've been able to help him on a number of occasions with various issues, both hardware and software.
I admit to not knowing the complete specs of the PCI bus. What I do know is that I'm trying to buy a disk drive subsystem that'll last for quite some time - and I'm hoping "quite some time" is longer than three years. After I could afford it, all I ever bought was SCSI until I got this #%@ Dell. I've had to do serious and continuous surgery on it to keep it going. What I'm attempting to do is make my entire storage strategy independent - and longer-lived - again.
This means several things to me: buy the best controller I can (but I also admit to not being sure if PCI-X is finalized yet); buy the best and fastest drives that I can; and make the entire thing bus-based rather than board-based.
Re: budget. Yes, of course that always an issue - but I'm one of those folks who prefer to endure major pain once rather than extended pain delivered in drips and drabs.
Re: usage. I'm an Oracle DBA by trade. Believe it or not, you can download Oracle 9.2 from Oracle's Web site if you'd like. And, believe *this* or not, it runs on XP Home - and I've gotten it to run on this PIII 500. BUT - I doubt I need to tell you guys what it runs like...
I'm going to be running Oracle (which I get legitamately through work) on a ~20G test database (that I'm going to be pulling over DSL in pieces). This will allow me to do testing and development at home - which'll get me outta the office 2 days/week if I'm lucky.
This is my current plan, anyway. I really appreciate everyone's feedback. Everything seems to have come much further than I'd thought. I'm by no means completely 100% convinced that SCSI is the way to go, btw - but that's where I'm leaning right now.