RE: [PHP-DB] Oracle 8 performance

I wonder if 1000 inserts is too few to draw valid conclusions, as any natural variation in the process may amount to 25% of the ( probably small ? ) elapsed time ! Try 100000 -> 1000000 inserts to make this factor less significant. Additionally truncate the table(s) and restart the database between each test ( to avoid any helping effects - like the first test causing the table to pre allocate enough space for both ! ) I will be interested to hear what you find. Cheers (Another) Mark > -----Original Message----- > From: Andrew Hill [SMTP:ahill@openlinksw.com] > Sent: Tuesday, October 03, 2000 3:18 AM > To: Mark Newnham; php-db@lists.php.net > Subject: 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 > > > > > > >