|
| 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/
|
|