Re: PEAR::DB is great but is sooooo SLOW !
| From: | Aidan Lister | Date: | Sun, 16 May 2004 11:22:24 +0000 |
| Subject: | Re: PEAR::DB is great but is sooooo SLOW ! | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-186347@lists.php.net to get a copy of this message | ||
There are many, many benchmarks done comparing PEAR::DB to PEAR::MDB to
AdoDB, PEAR::DB is much slower than the native API, AdoDB is the fastest but
least functional - I suggest you try PEAR::MDB2
http://pear.php.net/package/mdb2
once you get into it, you'll love it
"Rainer müller" <mueller_rainer@gmx.de> wrote in message
news:20040516110911.59603.qmail@pb1.pair.com...
> Greg wrote:
> > Hello,
> >
> > I've just performed a few tests when using PEAR::DB and
> > the results weren't good at all.
> >
> > If I compare a script using PEAR::DB with a script using
> > standard functions (and which supports mysql, pgsql and
> > sqlite databases), the script using PEAR::DB is 10 times
> > slower than the other.
> >
> > In one of my projects, it slows down execution time to
> > 0,7 sec per page !
> >
> > Conclusion : if you want to use PEAR::DB package, you'll
> > probably will have to use cache systems for scripts that
> > may be request often.
> >
> > Am I the only one annoying by this loss of performance ?
> > Because this is a huge loss in that case !
> >
> > Greg
>
> Remember, PEAR::DB also uses the standard functions, so I can't
> understand, why it should be much slower.
>
> Rainer