Subject Re: [firebird-php] (unknown)
Author .Christophe DERENNE
Hi,
I've no expérience with pdo : I always use native drivers.

But with native drivers, mysql is always the slowest, Firebird is not the fastest but not so far.

Christophe

2016-09-16 12:02 GMT+02:00 Lester Caine lester@... [firebird-php] <firebird-php@yahoogroups.com>:
 

On 16/09/16 10:14, Giacomo Quinti giacomo.quinti@...
[firebird-php] wrote:
> is the pdo driver for firebird so slower than the pdo driver for mysql?
> is it in a development upgrade? some one can test this problem in other
> installation to compare the two different pdo drivers?

Quick post as I am going out ...

I don't use PDO sticking with the generic drivers. Many other drivers
are slow in PDO as it tries to make other databases work like the lowest
common denominator - mysql.

Given the major differences in the way security is handled in mysql and
Firebird the difference does not surprise me, and it's query performance
which is more important. Most of the time I am running databases on
another machines so network traffic is more of a delay, and I suspect
mysql is bypassing that in this case. Databases are not already
'connected' to the server application in firebird like they are in mysql
so you have to open that connection.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page= contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk
Rainbow Digital Media - http://rainbowdigitalmedia.co. uk