Migrate MySQL to Ingres

We have a moderately complex PHP web app collecting data from a MySQL
database. We've been offered a rather attractive proposition to build an
Ingres version (ie. same app, but collects data from an Ingres database).

Questions for experts like you:

1) Is this a reasonably straightforward migration in which we can
largely replace mysql_query with ingres_query, etc, or will it be more
complex than that?

2) Does Ingres compare reasonably well with MySQL in terms of
scalability and speed?

3) Any dangers I should be aware of?

I am trying to decide whether or not to go forward with this project.
Your advice is much appreciated!

Thanks,

Jeff

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Migrate MySQL to Ingres

Jeffrey wrote:
> We have a moderately complex PHP web app collecting data from a MySQL
> database. We've been offered a rather attractive proposition to build an
> Ingres version (ie. same app, but collects data from an Ingres database).
>
> Questions for experts like you:
>
> 1) Is this a reasonably straightforward migration in which we can
> largely replace mysql_query with ingres_query, etc, or will it be more
> complex than that?
>
> 2) Does Ingres compare reasonably well with MySQL in terms of
> scalability and speed?
>
> 3) Any dangers I should be aware of?
>
> I am trying to decide whether or not to go forward with this project.
> Your advice is much appreciated!

Probably find an ingres mailing list and ask re: speed, scalability.

"In theory" you should be able to change between mysql & ingres easily,
but there will be issues probably with data (eg timestamps might be
handled or saved differently, autoincrement fields might be different).

Also stuff like full-text searching will most likely be different.

An ingres forum/list will most likely be able to point you to
differences to be aware of as well.

--
Postgresql & php tutorials
http://www.designmagick.com/

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Migrate MySQL to Ingres

On 13/05/07 17:12, Jeffrey scribbled:
> We have a moderately complex PHP web app collecting data from a MySQL
> database. We've been offered a rather attractive proposition to build
> an Ingres version (ie. same app, but collects data from an Ingres
> database).
>
> Questions for experts like you:
>
> 1) Is this a reasonably straightforward migration in which we can
> largely replace mysql_query with ingres_query, etc, or will it be more
> complex than that?
There are different functions provided by both the Ingres and MySQL
interfaces. That and the parameter order of equivalent functions do not
always match.
>
> 2) Does Ingres compare reasonably well with MySQL in terms of
> scalability and speed?
Yes and then some - don't just take my word for it since I work for
Ingres. If you wish to get the opinion of Ingres users go to
comp.databases.ingres
(http://groups.google.com/group/comp.databases.ingres/topics ) or
Ingres's own forums (http://community.ingres.com/)
>
> 3) Any dangers I should be aware of?
none that I am aware of.
> I am trying to decide whether or not to go forward with this project.
> Your advice is much appreciated!
Feel free to contact me directly if you have any further questions

regards

grant
Ingres PECL maintainer

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php