Re: OLTP - 50 MIllion/ hour?
From: "SG" <sg@abc.com> > >I am looking for info regarding OLTP installations that are currently >handling 50 million+ hits per hour. Size of each data for each transaction >is around 240 bytes. > >Can Informix handle this? Is anyone doing this kind of volume on Informix? Excuse my lack of comprehension: are you asking whether Informix can accept 50M+ inserts per hour, or 50M+ queries per hour or some combination of the two? If it's the former, I have just been doing some benchmarks, which may or may not be useful to you -- on a dinky little 2-way HP L-class UNIX box I've been inserting 100M 56-byte records into an unindexed table in around 80 minutes, well in excess of the speed you require. What may also be relevant to your requirements, was that the CPUs couldn't handle 100's of concurrent insert processes, but that was clearly just a function of the tin. (And I'm not knocking the tin either, it's a development box and it's being very heavily used.) I know a couple of mobile phone companies use Informix, this sounds like a mobile type of requirement? If you have more specific requirements, feel free to share. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
Thanks for your input. I should make it cleat that it is 50M+ queries per hour and it is a mobile type of requirement. Can you name the mobile companies? "Obnoxio The Clown" <obnoxio@hotmail.com> wrote in message news:8kqusk$mnr$1@news.xmission.com... > > From: "SG" <sg@abc.com> > > > >I am looking for info regarding OLTP installations that are currently > >handling 50 million+ hits per hour. Size of each data for each transaction > >is around 240 bytes. > > > >Can Informix handle this? Is anyone doing this kind of volume on Informix? > > Excuse my lack of comprehension: are you asking whether Informix can accept > 50M+ inserts per hour, or 50M+ queries per hour or some combination of the > two? > > If it's the former, I have just been doing some benchmarks, which may or may > not be useful to you -- on a dinky little 2-way HP L-class UNIX box I've > been inserting 100M 56-byte records into an unindexed table in around 80 > minutes, well in excess of the speed you require. What may also be relevant > to your requirements, was that the CPUs couldn't handle 100's of concurrent > insert processes, but that was clearly just a function of the tin. (And I'm > not knocking the tin either, it's a development box and it's being very > heavily used.) > > I know a couple of mobile phone companies use Informix, this sounds like a > mobile type of requirement? > > If you have more specific requirements, feel free to share. > > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com >