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
[EMAIL PROTECTED] 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 much
more. But "comparing" the performance of a database engine without
considering concurrent multi-user OLTP activity is very short-sighted. I
just finished some benchmark tests of MySQL ISAM, MySQL InnoDB, and Oracle
using Perl DBD. MySQL was fast with individual queries, inserts or updates
but it barfed as soon as I cranked up the number of sessions. Oracle flew
through 30 concurrent sessions with each session performing many different
queries. I was eager to further crank up the number of sessions (via a loop
in 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 others
in a wait state. MySQL InnoDB does row level locking but the InnoDB
developer (Heikki Tuuri) conceded that it InnoDB also barfs with multi-user
select, ins erts, updates and deletes so he's still working on it. The open
source MySQL community still has a lot of work to do to catch up to Oracle's
performance 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 Orr
Bozeman, Montana
-----Original Message-----
Sent: Monday, January 28, 2002 6:35 AM
To: Multiple recipients of list ORACLE-L
On 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 be
comparable 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
