Re: DB Engine/Server suggestions

From: datashark@fastlane.net > >Just got asked to create a database and make hardware suggestions for a >database which will hold..get this...5+ billion rows with up to 1000 >simultaneous users querying. Each record will consist of 2 fields only >in the table...one indexed character field and a second non-indexed >character field. That's it. I have never worked with anything of that >magnitude before, although I cleverly deduced that their desire to have >it run on an 8 processor NT would NOT be efficient. > >Pray tell which back end and what hardware would actually perform with >something of that magnitude? Gotta love that database design... :-) Have you considered trying a Sun Enterprise 10000 with 12 CPUs and Standard Engine? [One for our regular viewers!! :-] Anyway, you're definitely in the better than NT space here, machines to consider are: SGI Origin 2000 Sun Enterprise 10000 HP V2250 or greater IBM RS/6000 SP2 There are many others I have forgotten, for which I will surely be taken to task, but these are "mainstream". :-) I especially like the Origin, which last time I looked could cluster up to 6144 CPUs and (I think) 24 TB of RAM. Should just about cope. The others seem to have a 64 or 128 CPU clustering limit. Admittedly, even that's probably a bit much for what you're trying to do. :) ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com