Subject Re: Firebird - slow queries
Author csswa
Howdy.

One thing I'm curious about. Does Postgres and Mysql force writes by
default the way FB does? If not, it's not a level playing field. In
that case, try forced-write off with FB and inserts will be lots
faster...

Regards,
Andrew Ferguson
-- Usually the lesser of two evils.


--- In ib-support@y..., "Roodie" <istvanf@c...> wrote:

> The result was interesting:
> Mysql:
> Connection time: 0.017 sec,
> 1000 insert: 0.38 (without an index)
> 500 select: 0.28
> 500 select w. LEFT JOIN: 0.28
> Postgres:
> Connection time: 0.02
> 1000 insert: 2.67
> 500 select: 0.27
> 500 select w. LEFT JOIN: 0.28
> Firebird:
> Connection time: 0.22
> 1000 insert: 2.06
> 500 select: 1.6 !!!!!
> 500 select w. LEFT JOIN: 1.6!!!
>
> So I want to ask: where to look for this low performance?
> The interbase interface in PHP is broken?
> Or there is another issue I am not aware of?
>
> Any help appreciated.
>
> Roodie
> ICQ: 53623985
> email: istvanf@c...