[geeklog-devel] Pear DB Overhead

Tony Bibbs tony at tonybibbs.com
Thu Feb 6 17:09:32 EST 2003


Read this:

http://marc.theaimsgroup.com/?l=pear-dev&m=100793507904834&w=2

Sleep easier now?

--Tony

On Thu, 6 Feb 2003, Tom Willett wrote:

> Was surfing around and say this rather disturbing bit of info about php and 
> databases.  Well to put it simply PEAR DB appears to be about three times 
> slower that mysql -- here are the benchmark times.
> 
>         Average	 Overhead
> MySQL	 1.14	  -
> dbx      1.37     20% (index only)
> ADODB	 1.45	  27%
> dbx      1.53     34% (index/assoc/info)
> PhpLib	 1.60	  40%
> MDB      1.75	  54%
> PEAR DB  2.87	 152% (fetchInto)
> PEAR DB  3.15	 176% (fetchRow)
> M'base	 2.52	 296% (numeric cols)
> M'base	 4.77	 318% (assoc cols)
> 
> 
> 
> and a link to the full article.
> 
> http://phplens.com/lens/adodb/
> 
> --
> Tom Willett
> tomw at pigstye.net
> _______________________________________________
> geeklog-devel mailing list
> geeklog-devel at lists.geeklog.net
> http://lists.geeklog.net/listinfo/geeklog-devel
> 

-- 
------------------------------------------------------------------------|
Tony Bibbs         | "I guess you have to remember that those who don't |   
tony at tonybibbs.com | hunt or fish often see those of us who do as       |
                   | harmlessly strange and sort of amusing. When you   | 
                   | think about it, that might be a fair assessment."  | 
                   | --Unknown                                          |
------------------------------------------------------------------------|





More information about the geeklog-devel mailing list