RE: [PHP-DB] MySQL -> Oracle Migration From: Andrew Hill (ahill <email protected>)
Date: 11/17/00

Hi,

My .02

ODBC in not necessarily slower than native NET*8 or MySQL native
connections.

Evaluate your ODBC driver carefully - run the same kinds of statements (e.g.
some drivers run better with straight selects, bound parameters, stored
procedures, etc) that you are planning on using in your apps.

Obviously you should check Net*8 versus ODBC, sinch MySQL is only a dev
platform.

All in all though, ODBC can certainly be faster than native. Check out
http://www.openlinksw.com/main/softdld2.htm for the free version of
Openlink's Multi-Tier drivers. Let me know if you require assistance in
proving that ODBC is faster - I'll provide you with benchmarking tools,
etc., so you can test it in your own environment.

Best regards,
Andrew
----------------------------------------------------
Andrew Hill
Director Technology Evangelism
OpenLink Software
http://www.openlinksw.com
XML & E-Business Infrastructure Technology Provider

> -----Original Message-----
> From: Soma Interesting [mailto:dfunct <email protected>]
> Sent: Thursday, November 16, 2000 5:56 PM
> To: PHP General; PHP Database
> Subject: [PHP-DB] MySQL -> Oracle Migration
>
>
>
> I'd like some input on what considerations there are about developing a
> solution in MySQL that will ultimately be moved to Oracle. We're inclined
> to avoid the ODBC functions for better performance. I've seen some debate
> as to if ODBC actually significantly affects performance
> negatively. So my
> questions essentially are:
>
> 1) Is migrating from the MySQL -> Oracle functions a reasonable
> approach vs
> just using the ODBC functions.
> 1.5) What about migrating from ODBC functions directly to Oracle
> functions.
> 2) Are there already tools that will automate converting PHP code
> from one
> to another?
> 3) If we choose developing on MySQL and migrate to Oracle, are there
> considerations in how the code should be written to make the migration
> simpler?
>
> For example I found this comment on the PHP site:
>
> "It would be nice if we could have a mode to return the row as an object,
> just like mysql_fetch_object(), what do you think? It would be a
> lot easier
> to migrate from mysql to oracle.... :) "
>
> Thanks for your input.
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
>
>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>