Very Computer

by **Rajesh Kapu** » Fri, 07 Feb 2003 02:52:32

Our developers are lobbying to move from Java/Informix platform to PHP/MySQL
platform. I am advocating PHP/Informix combination because of my firm belief
in the superiority of Informix over MySQL, both from feature and stability
standpoint. The developers believe that PHP/MySQL will deliver a much
superior performance on Linux compared to PHP/IDS 9.30 combination. Can
someone please share your experience in this arena? Thanks.

by **Paul Watso** » Fri, 07 Feb 2003 08:03:44

Tried both combinations, PHP/Informix and PHP/MySql. Php is
straighforward, Mysql behaves in a similar manner to SE/Online 5 wrt
to performance, 9.x is significantly better.

> Our developers are lobbying to move from Java/Informix platform to PHP/MySQL
> platform. I am advocating PHP/Informix combination because of my firm belief
> in the superiority of Informix over MySQL, both from feature and stability
> standpoint. The developers believe that PHP/MySQL will deliver a much
> superior performance on Linux compared to PHP/IDS 9.30 combination. Can
> someone please share your experience in this arena? Thanks.

IMNHO your developer is a moron

--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #

by **Fernando Orti** » Sat, 08 Feb 2003 01:06:51

I have IDS 9.30 in a linux and another linux box with Apache/Php/CSDK.

PHP/Informix is pretty good combination. I'm switching all my previous ifx_*
code to use AdoDB to make the code database independent.

Maybe your app is so basic that you can use MySQL, but you should use Adodb
(or another DB abstraction layer) to be prepared to switch to a real
database just in case MySQL is not what you need, or to be ready to switch
to DB2 in a future.

HTH

----- Original Message -----

Sent: Wednesday, February 05, 2003 11:52 AM
Subject: PHP/MySQL vs PHP/Informix performance

> Our developers are lobbying to move from Java/Informix platform to
PHP/MySQL
> platform. I am advocating PHP/Informix combination because of my firm
belief
> in the superiority of Informix over MySQL, both from feature and stability
> standpoint. The developers believe that PHP/MySQL will deliver a much
> superior performance on Linux compared to PHP/IDS 9.30 combination. Can
> someone please share your experience in this arena? Thanks.

by **Francisco Rolda** » Sat, 08 Feb 2003 03:10:45

I can tell you that Mysql is very limited :
No Triggers, No Foreign Keys (you can define them but doesn't really work),
No stored procedures ...
The performance in huge transactional systems
Is very limited.

The only advantage of MySql is the cost, it is Free.

The best choice is IDS.

regards

-----Mensaje original-----

Enviado el: Jueves, 06 de Febrero de 2003 10:07 a.m.

Asunto: Re: PHP/MySQL vs PHP/Informix performance

I have IDS 9.30 in a linux and another linux box with Apache/Php/CSDK.

PHP/Informix is pretty good combination. I'm switching all my previous ifx_*
code to use AdoDB to make the code database independent.

Maybe your app is so basic that you can use MySQL, but you should use Adodb
(or another DB abstraction layer) to be prepared to switch to a real
database just in case MySQL is not what you need, or to be ready to switch
to DB2 in a future.

HTH

----- Original Message -----

Sent: Wednesday, February 05, 2003 11:52 AM
Subject: PHP/MySQL vs PHP/Informix performance

> Our developers are lobbying to move from Java/Informix platform to
PHP/MySQL
> platform. I am advocating PHP/Informix combination because of my firm
belief
> in the superiority of Informix over MySQL, both from feature and stability
> standpoint. The developers believe that PHP/MySQL will deliver a much
> superior performance on Linux compared to PHP/IDS 9.30 combination. Can
> someone please share your experience in this arena? Thanks.

by **Fernando Orti** » Sat, 08 Feb 2003 04:40:15

please note ...

----- Original Message -----

Sent: Thursday, February 06, 2003 12:10 PM
Subject: RE: PHP/MySQL vs PHP/Informix performance

> I can tell you that Mysql is very limited :
> No Triggers, No Foreign Keys (you can define them but doesn't really

work),

MySQL can handle foreign keys (and transactions) only if you install innodb
or another extension and the table you create with the syntax 'create table
... type=innodb'.

Please note, I really dislike MySQL as much as MS Access but for some really
small applications it may work.

> No stored procedures ...
> The performance in huge transactional systems
> Is very limited.

> The only advantage of MySql is the cost, it is Free.

> The best choice is IDS.

> regards

> -----Mensaje original-----

> Enviado el: Jueves, 06 de Febrero de 2003 10:07 a.m.

> Asunto: Re: PHP/MySQL vs PHP/Informix performance

> I have IDS 9.30 in a linux and another linux box with Apache/Php/CSDK.

> PHP/Informix is pretty good combination. I'm switching all my previous
ifx_*
> code to use AdoDB to make the code database independent.

> Maybe your app is so basic that you can use MySQL, but you should use
Adodb
> (or another DB abstraction layer) to be prepared to switch to a real
> database just in case MySQL is not what you need, or to be ready to switch
> to DB2 in a future.

> HTH

> ----- Original Message -----

> Sent: Wednesday, February 05, 2003 11:52 AM
> Subject: PHP/MySQL vs PHP/Informix performance

> > Our developers are lobbying to move from Java/Informix platform to
> PHP/MySQL
> > platform. I am advocating PHP/Informix combination because of my firm
> belief
> > in the superiority of Informix over MySQL, both from feature and
stability
> > standpoint. The developers believe that PHP/MySQL will deliver a much
> > superior performance on Linux compared to PHP/IDS 9.30 combination. Can
> > someone please share your experience in this arena? Thanks.