RE: Looking for a job...
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. > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org] On Behalf Of > elanleblanc@yahoo.com > Sent: Tuesday, May 30, 2006 18:34 > To: informix-list@iiug.org > Subject: Re: Looking for a job... > > > Double Echo wrote: > > ( IBM should be pushing Informix SE with PHP, and forget > about 4GL. > > PHP _is_ the next generation 4GL. JGP maybe you should try to get > > onboard with IBM and get them up to speed with PHP/Informix SE ) > > > > Why with SE? Why not IDS? Cost? > > If a development suite were no charge (the tools and the > database), but production/distribution was where the cost > kicked in, would more people develop on that base? > > Christine > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > >
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.