Hi!
The Zend article is somewhat outdated, because it says that MySQL does not
support transactions.
The benchmark the Zend article is referring to is the "TPC-C" benchmark
and the AS3AP-IR-select benchmark financed by Great Bridge LLC, a company
selling support for PostgreSQL.
I have written TPC-C in apostrophes because the benchmark was not
conducted according to the rules of TPC. They found out that
PostgreSQL was performing as well as two commercial databases,
but I believe the test was strictly disk-bound, and all sensibly written
database servers would get the same results.
In the AS3AP-IR-select test after some tuning MySQL was faster for
fewer than 7 users, PostgreSQL for more than 7 users. I think this test
is bound by the speed of the communication software between the client
and the server, because fetching a single row took some 1000 microseconds,
much more than is used internally inside the database server.
On my website http://www.innodb.com I have posted two simple tests
measuring the internal server CPU performance of PostgreSQL-7.1.1
and MySQL/InnoDB-3.23.39. In those tests MySQL/InnoDB is 4 - 11
times faster.
But it is best to run your own tests.
Regards,
Heikki Tuuri
Innobase Oy
>I'll have to pipe up and say that, empirically, mysql far outperforms
>postgres on a non-state-of-the-art server. I have seen 10 simultaneous
>connections to mysql and a system load of 0.1 versus 1 instance of
postgres
>(postmaster) and a load of over 2 (and with 3 instances of postmaster a
load
>of 8!)I know that hardware is cheap and obviously if I was running
exclusively
>postgres I'd throw more ram and a faster CPU at it.
>
>Regards,
>
>Gary "SuperID" Huntress
>=======================================================
>FreeSQL.org offering free database hosting to developers
>Visit http://www.freesql.org----- Original Message -----
>From: "Leon Mergen" <[EMAIL PROTECTED]>To: "Dip" <[EMAIL PROTECTED]>
>Cc: <[EMAIL PROTECTED]>Sent: Saturday, June 09, 2001 3:24 PM
>Subject: Re: Internals Of MySQL
> I recently read an article at Zend.com, showing that Postgres had better
> performance than MySQL... Offcourse, this is a very bad thing to say inthe
> MySQL mailing list, and I'm not really sure about it either, since so many
> praise MySQL...>> http://zend.com/zend/art/databases.php>
> _________________________________________> Leon Mergen> [EMAIL PROTECTED]
> President of Operations> BlazeBox, Inc.> T: +31 31 735 03 03
> F: +31 31 735 03 08> ICQ: 55677353>> ************************
> The information transmitted in this email is intended only for the
> person(s)or entity to which it is addressed and may contain confidential
> and/or privileged material. Any review, retransmission, dissemination or
> other use of, or taking of any action in reliance upon, this informationby
> persons or entities other than the intended recipient is prohibited. Ifyou
> received this email in error, please contact the sender and permanently
> delete the email from any computer.>>> ----- Original Message -----
> From: "Dip" <[EMAIL PROTECTED]>> To: <[EMAIL PROTECTED]>
> Sent: Saturday, June 09, 2001 8:55 PM> Subject: Internals Of MySQL>>
> > Hi All,> >
> > Im running some benchmarking tests on mysql, postgres and interbase
> > database servers.> >
> > does anyone know the reasons why or know where i can find out some
> > technical reasons why the mysql database server is particularly good in
> > relation to the others or just by itself e.g. use of query optimisation
> > or indexing etc. I'm only looking at creates, selects, inserts, update
> > and delete statements.> >
> > I've tried to look around for this on the net, but all i seem to get is
> > a big arguement consisting of the features lacking in mysql that are in
> > other databases e.g. ACID!!> >> > Thanks,> >> > Dipesh> >> >> >> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php>
>> >
>>> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
