| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Benchmark Myopia
what happens if the man walks and the dragster runs out of gas after four miles?
-----Original Message-----
Sent: Monday, January 28, 2002 1:45 PM
To: Multiple recipients of list ORACLE-L
A few years ago I saw a show where a guy won a bet saying he could win a race against the world's fastest high performance dragster... on foot! Of course the dude on foot got to define the race. The length of the race was only about 10-20 feet. The man on foot and the dragster edged up to the starting line and the tension mounted as the starting lights went down the tree to green. Everything was filmed in slow motion and there was visible proof that the man on foot beat the dragster to the finish line only a few feet away. A few seconds later the dragster was deploying its parachute a quarter a mile away but it lost the 20 foot race.
MySQL is like the man on foot... it may win the 20 foot race but who cares because the real race must be a distance that reflects real work. To me the real race is more like the Baja 1000 and I could probably beat the dragster in my Ford Explorer.
Steve
-----Original Message-----
Sent: Monday, January 28, 2002 10:11 AM
To: Multiple recipients of list ORACLE-L
HI Steve,
A good example of why words ambiguous words like faster are dangerous. I
have often asked clients the question which is faster a Ferrari Roadster or
a
Mack Truck. Invariably the answer would be the Ferrari, I then answer that
it depends on what you are trying to do. If you are trying to drive to
work,
definitely the ferrari, if you trying to move the contents of your house
across
country you would probably want to take the Mack truck, so the answer is
"It depends" again. Until you know the intended usage, faster, doesn't
mean
alot.
My .02,
John
sorr_at_rightnow.com wrote:
It's faster than Oracle.
Oh... You hit a hot button!!!MySQL is faster at performing 1 query in 1
database session and not muchmore. But "comparing" the performance of a
database engine withoutconsidering concurrent multi-user OLTP activity is
very short-sighted. Ijust finished some benchmark tests of MySQL ISAM, MySQL
InnoDB, and Oracleusing Perl DBD. MySQL was fast with individual queries,
inserts or updatesbut it barfed as soon as I cranked up the number of
sessions. Oracle flewthrough 30 concurrent sessions with each session
performing many differentqueries. I was eager to further crank up the number
of sessions (via a loopin Perl) but MySQL crapped out so there was no point
going any further.MySQL ISAM does table level locking and one session would
put all the othersin a wait state. MySQL InnoDB does row level locking but
the InnoDBdeveloper (Heikki Tuuri) conceded that it InnoDB also barfs with
multi-userselect, ins
erts, updates and deletes so he's still working on it. The opensource MySQL
community still has a lot of work to do to catch up to Oracle'sperformance
when it comes to any real world multi-user database activity.MySQL faster
than Oracle? This is a pearlescent example of benchmark myopia.IMHO,Steve
OrrBozeman, Montana-----Original Message-----Sent: Monday, January 28, 2002
6:35 AMTo: Multiple recipients of list ORACLE-LOn Monday 28 January 2002
03:45, Marin Dimitrov wrote:
maybe u could consider some free databases?of course the performance,
functionality and the ease of use won't becomparable to MS SQL but many
sites use such databases quite successfully
Actually, the most popular of the free databases is mySql, which is likely
faster than MS Sql. It's faster than Oracle. Jared
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Orr, Steve
INET: sorr_at_rightnow.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jan 28 2002 - 14:50:20 CST
 |
 |