Subject | Re: Ineteresting article............ but in czech |
---|---|
Author | Adam |
Post date | 2005-10-30T23:27:54Z |
Firstly, thanks to Jakub for the translation.
Secondly, the results are obviously not real world results. If so,
absolutely no-one would use MySQL, and PostgreSQL would be even less
popular. I am not suggesting the author had any bad intentions,
perhaps he just chose by coincidence queries that Firebird handles
well and the others dont. I know that we would dismiss the paper if it
compared a select count(*) query.
Perhaps the PHP-Firebird components are more mature than the ones he
used to connect to the others (although I doubt this could be true for
MySQL, LAMP). Maybe the interface layer caused a bottleneck.
More likely though, it is a testament to the self-tuning-ness of
Firebird. Straight out of the box, Firebird generally has good
performance. While there are a few parameters that can help in certain
configurations, this is one of its key strengths. The hardware is
relatively modest (in a DBMS server sense), and that is another
strength of Firebird.
I do love it when Firebird comes out on top of benchmarks, but not at
the expense of the integrity of the conclusions reached. Perhaps a
larger test using a lot more sample queries, complex joins etc
repeated across several different interfaces PHP / C / Java / .Net /
Delphi etc would give a more accurate picture of dbms performance.
Adam
--- In Firebird-general@yahoogroups.com, Lester Caine <lester@l...> >
I use PHP heavily now in distributed apps, I *AM* interested in how the
Secondly, the results are obviously not real world results. If so,
absolutely no-one would use MySQL, and PostgreSQL would be even less
popular. I am not suggesting the author had any bad intentions,
perhaps he just chose by coincidence queries that Firebird handles
well and the others dont. I know that we would dismiss the paper if it
compared a select count(*) query.
Perhaps the PHP-Firebird components are more mature than the ones he
used to connect to the others (although I doubt this could be true for
MySQL, LAMP). Maybe the interface layer caused a bottleneck.
More likely though, it is a testament to the self-tuning-ness of
Firebird. Straight out of the box, Firebird generally has good
performance. While there are a few parameters that can help in certain
configurations, this is one of its key strengths. The hardware is
relatively modest (in a DBMS server sense), and that is another
strength of Firebird.
I do love it when Firebird comes out on top of benchmarks, but not at
the expense of the integrity of the conclusions reached. Perhaps a
larger test using a lot more sample queries, complex joins etc
repeated across several different interfaces PHP / C / Java / .Net /
Delphi etc would give a more accurate picture of dbms performance.
Adam
--- In Firebird-general@yahoogroups.com, Lester Caine <lester@l...> >
I use PHP heavily now in distributed apps, I *AM* interested in how the
> time differences are achieved. Especially if it will provide moreresults!
> information for my papers in two weeks time ;)
>
> While I don't really have the time, perhaps I should install a copy of
> MySQL and Posgres and run the bitweaver site on each to compare the
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services
> Treasurer - Firebird Foundation Inc.
>