RE: Memory Management

> Date: Mon, 6 Sep 2010 17:19:32 +0100 > From: obnoxio@serendipita.com > To: informix-list@iiug.org > Subject: 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... > Well you'd want Enterprise Edition (or whatever they are calling it) and build 2 systems for HA/ER. (Load balancing even? ;-) Of course here's a question about pricing... Linux sees these e5500 quad core machines as having 8 cores because it recognizes the dual threads per core. So how does IDS pricing see it? 4 cores or 8 per socket? BTW... even at 20K, IDS is the most expensive component of the system. (Although I haven't priced out memory over 32GB but I doubt its that expensive. ;-)