Re: DB performance
| From: | Tomas V.V.Cox | Date: | Sat, 06 Oct 2001 18:03:06 +0000 |
| Subject: | Re: DB performance | ||
| References: | 1 2 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-2165@lists.php.net to get a copy of this message | ||
> >
> > yes, that was me. but i wouldn't call those benchmark tests
> > scientifically correct :) and i didn't test it with the "native" backend
> > functions. just a pear to phplib comparison. See
> >
> > http://marc.theaimsgroup.com/?l=php-pear&m=98396772605723&w=2™{³°ôŠSk|
> > æã§ÉA¡
> > for the thread
> >
>
> You could increase the performance just moving the code of DB.php,
> common.php and <native>.php (and perhaps PEAR.php) into one file. Also
> there are a lot of constants definitions that aren't really needed.
> Ummm.. I'll do some benchmarks.
>
Here are the results:
Standar distrib:
require 62.39
connect 69.231
query 8.226
fetch_loop 3.369
Stop 0.323
All in one file (PEAR.php, DB.php, common.php & pgsql.php)
require 107.028
connect 4.05
query 7.726
fetch_loop 3.862
Stop 0.324
Tomas V.V.Cox