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
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php