RE: [PHP-DB] Oracle 8 performance

Mark, ODBC, properly written, will bypass SQLNet and allow your client app (PHP) to deal directly with the CLI of the database. In addition, ODBC can enforce additional functionality onto back end databases, and one of the results of this can be speed. E.g. the driver will have a better fetch-buffer-size (fewer hops) and robust cursor support (more efficient handling of result-sets). You will also find some huge differences in ODBC drivers as well. Hope this helps. Best regards, Andrew ---------------------------------------------------- Andrew Hill Director Technology Evangelism OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technology Provider > -----Original Message----- > From: Mark Newnham [mailto:mnewnham@adacorp.com] > Sent: Friday, September 29, 2000 6:20 PM > To: 'php-db@lists.php.net' > Subject: [PHP-DB] Oracle 8 performance > > > I ran a simple test (insert 1000 records) into an oracle 8i database using > both odbc and oci (php_oci8.dll). To my suprise the odbc driver is almost > 25% faster than the native mode. I would have expected the results to turn > out the other way - or am I misunderstanding the whole purpose of > the native > mode drivers. > > Any thoughts/resources on this would be appreciated. > > Regards > > Mark > > ##################################################### > Mark Newnham > Application Design Associates, Inc > 6021 S.Syracuse Way #302 > Englewood, CO 80111, USA > > http://www.adacorp.com > ##################################################### > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >