Re: Looking for a job...

Jean Georges Perrin wrote:
Christine,

Playing devil's advocate, with MySQL all is free, BUT... I had a very
serious hardware crash (disk dead) on an IDS installation and I recovered
Informix from memory, no data loss. I have a power lost problem with MySQL,
innodb was dead and we had to recover from tapes, 24h of data lost.


InnoDB is a very basic, rudimentary "plug-in", to do transactions on MySQL.
But it is horribly designed, with very little choices in how you architect
disk usage. It could never compete seriously with IDS or Oracle or even
Sybase on the same playing field. But, the key is, and something important
for everyone to notice, they occupy the drive, and Informix does not. In
that regard they are stealing Informix's lunch, and keeping Informix out.

InnoDB is a good alternative in environments where there may be emerging
development off "corporate radar" where transactions are required, and
the project may be speculative and a "real" transaction-based database may
not be available. You don't have to use PHP either, any development front
end with ODBC will work.

Despite InnoDB's poor architecture, its usage is also unique in that you can
convert tables to/from InnoDB to MyISAM rapidly, for whatever reason you choose.
This is not possible with Informix SE. SE has probably a few features that
MyISAM tables do not, but it doesn't really matter, there's a whole generation
of developers who will never use SE.

Also keep in mind that MySQL may not be an "IDS", but it is certainly more
like Standard Engine than any other product from Informix. It is very visible,
very much talked about in the market, probably even more so than DB2 and certainly
more talked about than Informix.

Unfortunately it doesn't really matter since IBM's stellar Informix marketing
machine doesn't get how similar they are, and thusly this is only an academic,
futile discussion.

.

Relevant Pages

  • Re: IIUG Board election results
    ... I love to take mySQL on with IDS... ... Not sure IBM knows how to spell SMB! ... Informix while on the other hand she wanted to kill it. ...
    (comp.databases.informix)
  • Re: XPS to IDS - a positive note for all from the road
    ... He must have been one of Janet's hand picked "boyz" because from an IDS person' s view, he's put hit foot in his mouth far too many times. ... and a lot of the up-and-coming developers are already knee deep in it. ... with products like MySQL, which has embraced web 2.0 and the whole next ... Informix needs to start from scratch ...
    (comp.databases.informix)
  • RE: Problem with Windows domain users
    ... Problem with Windows domain users ... As of IDS 10.00.TC6 the situation was not good and I'm sorry for the ... bring this to the attention of IBM technical support some time ago. ... the localsystem user instead of the informix user? ...
    (comp.databases.informix)
  • Re: Losing Precision from FLOAT in DBD::Informix
    ... The versions of CSDK and IDS are also not ... STSM, Informix Database Engineering, IBM Data Management ... >> are declared FLOAT. ... >> - where and why is the precision lost? ...
    (perl.dbi.users)
  • Re: Re: Informix in the news! Part Deux...
    ... Maybe IDS will need to come to a point like derby for this to happen, ... Subject: Re: Informix in the news! ... > engaged with the vendors mentioned below as well as many others. ... they don't have to worry about the future of DB2, ...
    (comp.databases.informix)