Subject | Re: Firebird - slow queries |
---|---|
Author | csswa |
Post date | 2002-05-13T14:09:27Z |
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.
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...