Re: [PHP-DB] 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
Re: [PHP-DB] 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
[PHP-DB] 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