Re: Benchmark Myopia

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