RE: [PEAR] Re: DB vs. MDB, a speed issue.
| From: | Lukas Smith | Date: | Sun, 27 Jul 2003 18:53:47 +0000 |
| Subject: | RE: [PEAR] Re: DB vs. MDB, a speed issue. | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-6850@lists.php.net to get a copy of this message | ||
> From: Manuel Lemos [mailto:mlemos@acm.org]
> Sent: Saturday, July 26, 2003 7:36 PM
> On 07/26/2003 03:36 AM, Stan Lemon wrote:
> > Ok, I'm looking for the fastest way to retreive information out of a
> > database, pump it into an array and work from there. I've been
useing
> > DB, but I'm wondering if MDB is a better route? I pretty much, run
> > query, fetchRow, and occasionaly numRows, but that's it. Speed is
an
> > issue, so I am wondering, do we know which one is faster?
>
> If speed is an issue, do not use any database abstraction at all.
Always
> use PHP native database API functions directly.
>
> DB provides a common API but your applications will not be database
> independent by themselves. MDB provides database independence. Each of
> them add overhead when compared to calling native database API
> functions. Between speed maximization and portability, you will not
have
> both.
That is also correct.
Regards,
Lukas