Re: Memory Management
Growth Edition can have up to three nodes ER or HDR are both supported. No need for Ultinate Edition just for HA. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Sep 6, 2010 at 12:38 PM, Ian Michael Gumby <im_gumby@hotmail.com>wrote: > > > > 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. ;-) > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >