From: Roberto Mello <rmello@cc.usu.edu>
To: Clayton Cottingham aka drfrog <drfrog@smartt.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: any proper benchmark scripts?
Date: Thu, 19 Apr 2001 09:42:13 -0600
Message-ID: <20010419094213.A31892@cc.usu.edu> (raw)
In-Reply-To: <200104190209.f3J29Yj06260@smartt.com>
References: <3ADC8D97.23D5E339@smartt.com>
<200104190209.f3J29Yj06260@smartt.com>
On Wed, Apr 18, 2001 at 07:00:24PM -0700, Clayton Cottingham aka drfrog wrote:
"Benchmarks" comparing MySQL to anything else usually make the worst
and lowest denominator compromise (which obviously favours MySQL).
- What table types did you use on MySQL? Did you use the BDB (or
whatever the transaction tables are called) or ISAM tables? If you
didn't use transactional tables, it's not a fair comparison.
- In PostgreSQL, did you do the inserts in a single transaction block
or just did what MySQL users usually do because they know what a
transaction is, and left every INSERT on its own (effectively
putting each on its transaction block)?
If you didn't put the inserts into a single transaction block, then
it's not a realistic test because that's not what you would do in
real life in a real database system (pretty much anything besides
MySQL and Access).
>
> correct me if im wrong but if fast_db.pl is
> working right
> first set is insert
> second set is select
Speed is good. But it's not everything. You should do it right, then
make it fast. MySQL implementors don't care about doing it right. They
just care about making it fast.
My filesystem is much faster than the MySQL filesystem (that's what it
is). UDP is faster than TCP, but TCP is better and more reliable. A
skydiver without a parachute will always fall faster than the one with
parachute. The skydiving school will say "we make your fall more exciting,
and much faster than our competitors." and the dumb skydivers will reply
"well, if you make my fall faster, then of course you're the best".
Which one will survive the fall?
Comparing MySQL to PostgreSQL, Oracle or any other real database is
like comparing DOS with UNIX, or Emacs with an orange.
-Roberto Mello
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.nethttp://www.sdl.usu.edu - Space Dynamics Lab, Developer
I wonder what this button does? *&^(&^)#@$*&_% NO CARRIER
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: rmello@cc.usu.edu, drfrog@smartt.com
Subject: Re: any proper benchmark scripts?
In-Reply-To: <20010419094213.A31892@cc.usu.edu>
References: <3ADC8D97.23D5E339@smartt.com> <200104190209.f3J29Yj06260@smartt.com> <20010419094213.A31892@cc.usu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox