Re: Re: No future for DB2



"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.


.



Relevant Pages

  • Buku Murah Berkualitas, Koleksi Terbaru Bulan Mei 2008
    ... => Bio-MEMS Technologies and Applications, Wanjun Wang, Steven ... => Powersim Studio 2003 Users Guide, Powersim, Powersim, Rp161,000, ... Release 12, ORACLE, ... Discrete Mathematics, 3rd ed, Symour Lipschutz, ...
    (soc.culture.indonesia)
  • Govt - Oracle Developer Job ID: ESI-H-FX 1077
    ... ?Oracle, PLSQL, SQLPlus, Able to write large applications in PL/SQL ... ?They will also have strong organizational skills and solid oral and written communication skills. ... ?Reporting to an Application Team Lead, you will be responsible for designing, coding, and unit testing applications that affect a web-based system used across North America ... and not miss out on contacting you faster for these opportunities" ...
    (comp.lang.c)
  • Ford and Oracle
    ... Ford kills 'Everest' procurement software system ... major procurement software system built around Oracle Corp.'s 11i E-Business ... Suite of applications. ... Everest, and collapse its purchasing processes around its original ...
    (comp.os.vms)
  • Re: blade 100 -> blade 150 -> next?
    ... ton de w wrote: ... including Oracle 9. ... The blade 150s are faster than the 100s, but still a bit slow for some ... and I use it mostly for testing new applications (including ...
    (comp.unix.solaris)
  • Re: Newbie: Creating new database files
    ... With Oracle it appears that there is a central database area underneath the Oracle directory tree which will contain data for all applications using it. ... The Concepts Guide is only 1% or less of the complete documentation set but it has more information about Oracle packed into it than any other source I have seen. ...
    (comp.databases.oracle.misc)