Re: oci8 numrows

I am curious. When you say you say you are going to rewrite some clasess in C. It confuses me since I thought pear was php only, no C. Where would this C files go ? as php extensions ? greets _____edmz_ "Stig Sæther Bakken" <ssb@fast.no> wrote in message news:m366gzy9jm.fsf@kirin.trondheim.fast.no... > [bmansion@localhost.hst.nerim.net] > > Hi, > > > > It\'s good to have numrows with oci8.php. Thanks Stig. > > I have tested this on Win 2000 Server with Oracle 8.1.5 and Php 4.0.4, it > > works fine, and made some benchmarks using Benchmark/Timer.php. > > > > First, I have noticed that on Oracle, count(*) is faster than > > count(FIELD1,FIELD2...). Strange. The difference is not big enough to > > change it, though. > > > > Then I compared PEAR DB to PHPlib DB. > > It appears that there is a huge difference on connection times. I did not > > take into account the time it takes to require the different prepend and > > class files. > > That's because DB::connect triggers parsing of DB/common.php and > DB/dbtype.php. There's a lot more code to parse in PEAR DB. To > rectify this, I'm going to convert the DB_common class to C (in the > short term), and in the long term convert the DB_dbtype classes > themselves to C as well. > > > Connection to Oracle > > PEAR DB 240 ms with plogon (slower with ocilogon) > > PHPLIB 1 ms > > > > Other than that, there is no big differences, PHPlib being a little > > bit faster but with less features (error management, query > > manipulation...). > > Is DB_oci8 connecting in the "optimal" way? I seem to remember that > the Oracle connection time varied wildly depending on what connect > parameters you used (at least "TNS name" versus ORACLE_SID). > > - Stig > > -- > Stig Sæther Bakken <ssb@fast.no> > Fast Search & Transfer ASA, Trondheim, Norway > > -- > PEAR Development Mailing List (http://pear.php.net/) > To unsubscribe, e-mail: pear-dev-unsubscribe@lists.php.net > For additional commands, e-mail: pear-dev-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >