[geeklog-devel] Pear DB Overhead
Tom Willett
tomw at pigstye.net
Thu Feb 6 18:04:33 EST 2003
So with the enhancements its only 1/2 speed instead of 1/3 speed?
My concern is that even now people complain about speed. When they see that
it takes twice as long to render a page, they will really complain. Much of
the speed issue now is because of uneeded and redundant db calls done in the
name of programming ease. As I see the design of GL2, this will only get
worse. A bunch of independent modules do not tend to share the information
they pulled from the db.
Tom
On Thu, 6 Feb 2003 16:09:32 -0600 (CST), Tony Bibbs wrote
> 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 |
> ------------------------------------------------------------------------|
>
> _______________________________________________
> geeklog-devel mailing list
> geeklog-devel at lists.geeklog.net
> http://lists.geeklog.net/listinfo/geeklog-devel
--
Tom Willett
tomw at pigstye.net
More information about the geeklog-devel
mailing list