PHP MySQL Driver Choice -- Fastest?

PHP MySQL Driver Choice -- Fastest?

am 19.11.2008 22:00:34 von Micah Gersten

Which is the fastest driver for this?
ADODB
PDO
mysqli
Anything else?

--


Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP MySQL Driver Choice -- Fastest?

am 19.11.2008 22:59:02 von dmagick

Micah Gersten wrote:
> Which is the fastest driver for this?
> ADODB
> PDO
> mysqli

Either mysqli or pdo since they'd deal with the mysql client directly.

ADODB is a php library, so it's not going to be as fast because you have
php code overhead.

--
Postgresql & php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP MySQL Driver Choice -- Fastest?

am 19.11.2008 23:59:17 von Yves Sucaet

How does the "default" php_mysql.dll compare to these? Is mysqli faster t=
han
mysql?

tia,

Yves

------ Original Message ------
Received: Wed, 19 Nov 2008 04:00:46 PM CST
From: Chris
To: Micah Gersten Cc: PHP DB
Subject: Re: [PHP-DB] PHP MySQL Driver Choice -- Fastest?

Micah Gersten wrote:
> Which is the fastest driver for this?
> ADODB
> PDO
> mysqli

Either mysqli or pdo since they'd deal with the mysql client directly.

ADODB is a php library, so it's not going to be as fast because you have =

php code overhead.

-- =

Postgresql & php tutorials
http://www.designmagick.com/


-- =

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php






--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP MySQL Driver Choice -- Fastest?

am 20.11.2008 00:22:04 von Micah Gersten

Chris wrote:
> Micah Gersten wrote:
>> Which is the fastest driver for this?
>> ADODB
>> PDO
>> mysqli
>
> Either mysqli or pdo since they'd deal with the mysql client directly.
>
> ADODB is a php library, so it's not going to be as fast because you
> have php code overhead.
>

ADODB is precompiled for PHP5. Do you know of any tests?

Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP MySQL Driver Choice -- Fastest?

am 20.11.2008 00:35:33 von dmagick

Micah Gersten wrote:
> Chris wrote:
>> Micah Gersten wrote:
>>> Which is the fastest driver for this?
>>> ADODB
>>> PDO
>>> mysqli
>> Either mysqli or pdo since they'd deal with the mysql client directly.
>>
>> ADODB is a php library, so it's not going to be as fast because you
>> have php code overhead.
>>
>
> ADODB is precompiled for PHP5. Do you know of any tests?

It's a dll or .so file?

--
Postgresql & php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP MySQL Driver Choice -- Fastest?

am 20.11.2008 00:36:10 von dmagick

YVES SUCAET wrote:
> How does the "default" php_mysql.dll compare to these? Is mysqli faster than
> mysql?

I'd call that a native driver.

No idea about mysqli vs mysql.

--
Postgresql & php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP MySQL Driver Choice -- Fastest?

am 20.11.2008 00:49:30 von Micah Gersten

Chris wrote:
> Micah Gersten wrote:
>> Chris wrote:
>>> Micah Gersten wrote:
>>>> Which is the fastest driver for this?
>>>> ADODB
>>>> PDO
>>>> mysqli
>>> Either mysqli or pdo since they'd deal with the mysql client directly.
>>>
>>> ADODB is a php library, so it's not going to be as fast because you
>>> have php code overhead.
>>>
>>
>> ADODB is precompiled for PHP5. Do you know of any tests?
>
> It's a dll or .so file?
>

On Linux, it's an .so file, yes:
http://packages.debian.org/lenny/i386/php5-adodb/filelist

Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP MySQL Driver Choice -- Fastest?

am 20.11.2008 01:03:01 von dmagick

Micah Gersten wrote:
> Chris wrote:
>> Micah Gersten wrote:
>>> Chris wrote:
>>>> Micah Gersten wrote:
>>>>> Which is the fastest driver for this?
>>>>> ADODB
>>>>> PDO
>>>>> mysqli
>>>> Either mysqli or pdo since they'd deal with the mysql client directly.
>>>>
>>>> ADODB is a php library, so it's not going to be as fast because you
>>>> have php code overhead.
>>>>
>>> ADODB is precompiled for PHP5. Do you know of any tests?
>> It's a dll or .so file?
>>
>
> On Linux, it's an .so file, yes:
> http://packages.debian.org/lenny/i386/php5-adodb/filelist

Didn't know that :) Cool.

--
Postgresql & php tutorials
http://www.designmagick.com/


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php