Re: Memory Management

Ian Michael Gumby wrote: > > > > From: domusonline@gmail.com > > Subject: Re: Memory Management > > Date: Sun, 5 Sep 2010 23:32:32 +0100 > > To: informix-list@iiug.org > > > > > > Thanks all..great information. I agree that 6 Million is not really > > > that big since the big RDBMSs can navigate 100's of millions of > > > records but, sorry to say, Informix isnt on the list of the top RDBMSs > > > so I wasnt sure. I will have a different view of Informix from now > > > on. I do have to say that I am pretty impressed by all that I have > > > researched so far and puzzled why it is not in the running with > > > Oracle, DB2 and MS. > > > > > > > Because in the current "fast" world nobody does what you're doing... > > I'd say people do this associations: > > > > MS -> Cheap & easy > > Oracle -> Leader > > DB2 -> IBM (for better and for worst) > > > > Sigh. > > Define by what you mean "fast". > > If you're talking strictly RDBMS for OLTP (read TPC-C type > benchmarking), Informix probably blows the competition away on the Intel > e5500+ series. > The reason I say probably is that well, IBM doesn't *do* benchmarks > using Informix. (Even though Jerry K. hinted at it some time ago but > was again forced to back peddle because well IDS isn't DB2.) > (And nobody but mainframe dominated shops want DB2 LUW.) > > Imagine this... 2 socket 4 core e5500 series Intel chips. (This is *now* > a commodity hardware platform BTW...) Put this in to a 4U high box, and > two "high end" SAS/SATA controller that can do 6.0 gbs (SATA III). > I forget who posted this out of Germany but you're better off using > SSDs over the FusionIO cards, so taking his word, go with 2.5" SSDs. (I > believe that SATA III drive are actually cheaper than SATA II now...) > If the motherboard doesn't have 10GBe, you can get a seriously good card > from Solarflare. > > Fully loaded a machine would set you back $12-15K fully loaded with > 64-96GB of memory. > > Go run your TPC-C and calculate your cost per transaction. > > Your most expensive component will be the cost of the IDS engine running > on 8 cores. 2 socket x 4 cores of Growth Edition would cost $20,000 at list. I'm not entirely sure you're making a good case here... -- Cheers, Obnoxio The Clown http://obotheclown.blogspot.com I will now proceed to pleasure myself with this fish. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.