Re: oci8 numrows

Hi, PEAR is intended for both extensions and PHP code (the "E" in PEAR is for "extension"). The fact that we don't have many C extensions yet is just due to the fact that we don't have a proper framework for it yet. - Stig ["news.php.net" <susc@emonterrey.com>] > 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 > > > > > > -- > 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 > -- Stig Sæther Bakken <ssb@fast.no> Fast Search & Transfer ASA, Trondheim, Norway