Re: Memory Management

Ian Michael Gumby schrieb: > > >> 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. I bet the mentioning of Fusion-IO must have been me. And IBMmers DO lurk c.d.i. Why? Just have a look on ibm.com for the eX5 SSD options :-' dic_k > -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe