Re: [Phplib-users] phpLib Wrapper for PEAR

[Bob B. <bo...@iN...>]

Hi --

Preliminary results of PEAR vs phpLib timing tests ... each function did a 
basic SELECT plus a sys-procedure look-up-and-query, and the function was 
repeated 100 times in a set.  The sets of 100 have themselves been repeated 
several times, and the results are within 2/10,000ths of a second for each 
function over a total of about 10,000 queries.  The straight connection to 
the database (not a p_connect) was not timed ...

         PEAR            0.0058 seconds each over a set of 100
         phpLib          0.0062 seconds each over a set of 100

Each function, repeated 100 times, performed the following steps on a MySQL 
database table where field1 is the Primary Key and field10 and field11 are 
each keys. "$timer" is a class which returns microsecond elapsed times, 
"proc()" looks up the requested sys procedure, and "execproc()" inserts the 
variables then executes the query.

<PSEUDOCODE>
   $timer->start()
   SELECT field1,field4,field10,field11 FROM table ORDER BY field1 LIMIT 10
   seek(2)
   proc("dailySummaryAll")
   $argv = array(LONGDATE=>"0901",SHORTDATE=>"901")
   execproc($argv)
   $timer->stop()
   $runTot += $timer->gettime()
</PSEUDOCODE>

Next up: we'll time connections, then inserts, joins and heavier 
calculations ...

We're doing this because the "complaints" about PEAR being slower didn't 
seem to bear out, based on "gut feelings".  So we're doing head-to-head 
tests with PHP4 on a production server with MySQL ...

Any suggestions, requests, thoughts, contrary results, ...???

Bob.

At 07:29 PM 9/4/01 -0700, you wrote:
>Hi --
>
>Has anyone actually written a class to use phpLib function names but with 
>PEAR classes doing the work ...?
>
>We worked one up late last month (including sys procedures), and have it 
>working just fine using the latest PEAR and its DB class with MySQL ... we 
>are going to do some apples-to-apples speed tests this week using scripts 
>on a production site which is quite db intensive.
>
>But if anyone else has worked on this, I'd love to swap scripts, or hear 
>of your experiences, problems, etc. ...
>
>Nothing like "just doing it" as the best way to decide whether to keep 
>developing dynamic web sites with PHP4, phpLib and MySQL, or to 
>incorporate PEAR ...
>
>Bob.
>
>
>_______________________________________________
>Phplib-users mailing list
>Php...@li...
>https://lists.sourceforge.net/lists/listinfo/phplib-users