• in general, driver tuning doubled throughput
• Oracle9i's many separate memory caches made it the toughest to tune

• Memory per connection:
  • Oracle9i: 400Kb
  • MySQL, SQL Server, DB2: 50KB

• Without MySQL's in-memory query result cache (new in 4.0.1) performance dropped by 2/3. No other DB used this feature. If incoming query had byte-for-byte match MySQL can retrieve result directly from cache without compiling the query, getting locks or doing index access

• Conspicuously, they tested an all-Microsoft set of software (ASP.net, OLE DB, IIS) and they got a performance rating that beat out the MySQL setup by 870 to 620 or so.

-- MattWalsh - 13 Aug 2002