Re: Re: Re: No future for DB2

Online 5. as open source = Quite cool. J. -----Original Message----- From: "rkusenet" <rkusenet@hotmail.com> To: informix-list@iiug.org Date: Wed, 27 Jul 2005 12:41:50 -0400 Subject: Re: Re: No future for DB2 "Jean Sagi" <jeansagi@myrealbox.com> wrote in message news:1122479029.8c0a65f17276109f4e455911f99eca51@teranews... > I worked with oracle 6.5, 12 years ago, supporting an application I > received and its performace was _horrible_ (I don't blame oracle much > but the original developers). One of the things I had to frecuently > fight was with forms and pro*c applications that have huge querys... > very HUGE ones. > > Then by a twist of fate we get rid of oracle applications and went to > informix... online 5 (old at that time) and what a difference... > and temporary tables of course... that was a wonder to me that time. > > I firmly belive that oracle has evolved during these years and I really > don't know anything about recent oracle engines. Oracle has improved a lot, specially after 8i. But it becomes amusing when some Oracle DBA wants to pass off things like LMT (locally managed tablespace) as something unique. AFAIK, informix right from version 5 was maintaining dbspaces locally. It had never followed stupid dictionary managed tablespace. Informix online 5.x is still excellent DB for medium sized applications. I think it can easily handle 200-300 *concurrent* connections. Pity that it has not gone open source. It can wipe out MySQL. Jean Sagi jeansagi@myrealbox.com jeansagi@gmail.com sending to informix-list