Re: Re: No future for DB2
- From: "rkusenet" <rkusenet@xxxxxxxxxxx>
- Date: Wed, 27 Jul 2005 12:41:50 -0400
"Jean Sagi" <jeansagi@xxxxxxxxxxxxx> wrote in message news:1122479029.8c0a65f17276109f4e455911f99eca51@xxxxxxxxxxx
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.
.
- References:
- Re: Re: No future for DB2
- From: Jean Sagi
- Re: Re: No future for DB2
- Prev by Date: Re: Stateless clients and locking schemes (or rather isolation levels)
- Next by Date: Virtual Memory problems on Informix start up
- Previous by thread: Re: Re: No future for DB2
- Next by thread: Re: Re: Re: No future for DB2
- Index(es):
Relevant Pages
|
|