RE: Memory Management

Really. So what's missing from Growth that would want you to go Enterprise/Ultimate Ed? Datablades? Table Partitioning? Can IDS support the use of multiple indexes on a table within a query like XPS can? From: art.kagel@gmail.com Date: Tue, 7 Sep 2010 11:55:18 -0400 Subject: Re: Memory Management To: im_gumby@hotmail.com CC: obnoxio@serendipita.com; informix-list@iiug.org 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

"Ian Michael Gumby" <im_gumby@hotmail.com> wrote in message news:mailman.480.1283875344.1071.informix-list@iiug.org... >> So what's missing from Growth that would want you to go >> Enterprise/Ultimate Ed? >> Datablades? >> Table Partitioning? Well, since the recent re-branding, in 95% of sites that need Ultimate I'd say the show-stoppers for Growth are table partitioning and the16g memory limit.

> From: neil.truby@ardenta.com > Subject: Re: Memory Management > Date: Tue, 7 Sep 2010 21:44:37 +0100 > To: informix-list@iiug.org > > "Ian Michael Gumby" <im_gumby@hotmail.com> wrote in message > news:mailman.480.1283875344.1071.informix-list@iiug.org... > > >> So what's missing from Growth that would want you to go > >> Enterprise/Ultimate Ed? > >> Datablades? > >> Table Partitioning? > > Well, since the recent re-branding, in 95% of sites that need Ultimate I'd > say the show-stoppers for Growth are table partitioning and the16g memory > limit. > 16g is a waste on the e5500s. Seriously a sweet cpu. Table partitioning is also a key piece when you're dealing with large data sets that can be part of an OLTP system. So what's the current price tags (list price) for each version these days?

"Ian Michael Gumby" <im_gumby@hotmail.com> wrote in message news:mailman.486.1283908935.1071.informix-list@iiug.org... > From: neil.truby@ardenta.com > Subject: Re: Memory Management > Date: Tue, 7 Sep 2010 21:44:37 +0100 > To: informix-list@iiug.org > > "Ian Michael Gumby" <im_gumby@hotmail.com> wrote in message > news:mailman.480.1283875344.1071.informix-list@iiug.org... > > >> So what's missing from Growth that would want you to go > >> Enterprise/Ultimate Ed? > >> Datablades? > >> Table Partitioning? >> So what's the current price tags (list price) for each version these >> days?

> From: neil.truby@ardenta.com > Subject: Re: Memory Management > Date: Wed, 8 Sep 2010 08:55:11 +0100 > To: informix-list@iiug.org > > >From the IBM website: > Ultimate: US$38,600 per 100 "PVUs" > Growth: US$12,600 per 100 "PVUs". > > Typically 100 PVUs will cover a dual-core cpu. > > That's not all the story though: somewhat like Oracle Standard you can > licence smallish systems for Growth Edition by socket instead; this can be > excellent value for multi-cored servers. A socket licence is US$15,000. > Thanks OTC and Neil... So when you look at a quad core 2 socket... that's 200 PVUs per socket or 400 PVUs. == ~154K for Ultimate Or for Growth ... 50K but you have the memory limitation of 16GB. On a 8 core box 16GB is only 2GB per core... Not a lot when you consider each core has two threads so the machine sees it as 16 virtual cores... The point is that you *can* build out a 2 socket 8 core Linux box for under 5K, under 10K if you load it up on memory, SSDs, etc ... so that single box can support a *lot* of users. So you're going to get killed on the price of the software... Do you need parallel processing? Maybe not. Do you need to go beyond 16GB most likely unless you have a really small system and support a small number of users. Even still 50K is still a lot of money.