<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • Return to Table of Contents
    • Table of Contents
    1. General Information
    2. MySQL Installation
    3. Tutorial Introduction
    4. Database Administration
    5. MySQL Optimisation
    6. MySQL Language Reference
    7. MySQL Table Types
    8. MySQL APIs
    9. Extending MySQL
    50 MySQL Technical Reference for Version 4.0.3 1.9  How MySQL Compares to Other Databases Our users have successfully run their own benchmarks against a number of  Open Source and traditional database servers.  We are aware of tests against Oracle server, DB/2 server, Microsoft SQL Server,  and other commercial products.   Due to legal reasons we are re- stricted from publishing some of those benchmarks in our reference manual. This section includes a comparison with mSQL for historical reasons and with PostgreSQL as it is also an Open Source database.  If you have benchmark results that we can publish, please contact us at benchmarks@mysql.com. For  comparative  lists  of  all  supported  functions  and  types  as  well  as  measured  op- erational  limits  of  many  di erent  database  systems,   see  the  crash-me  web  page  at http://www.mysql.com/information/crash-me.php. 1.9.1  How MySQL Compares to mSQL Performance For a true comparison of speed, consult the growing MySQL benchmark suite. See Section 5.1.4 [MySQL Benchmarks], page 336. Because there is no thread creation overhead, a small parser, few features, and simple security, mSQL should be quicker at:    Tests that perform repeated connects and disconnects, running a very sim- ple query during each connection.    INSERT operations into very simple tables with few columns and keys.    CREATE TABLE and DROP TABLE.    SELECT on something that isn't an index.  (A table scan is very easy.) Because these operations are so simple, it is hard to be better at them when you have a higher startup overhead.   After the connection is established,  MySQL Server should perform much better. On the other hand, MySQL Server is much faster than mSQL (and most other SQL implementations) on the following:    Complex SELECT operations.    Retrieving large results (MySQL Server has a better, faster, and safer pro- tocol).    Tables with variable-length strings because MySQL Server has more e- cient handling and can have indexes on VARCHAR columns.    Handling tables with many columns.    Handling tables with large record lengths.    SELECT with many expressions.    SELECT on large tables.    Handling many connections at the same time. MySQL Server is fully multi- threaded. Each connection has its own thread, which means that no thread
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    MERCHANT ACCOUNTS
    DEDICATED SERVERS
    E-COMMERCE HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN
    REGISTRATION
    MANAGE
    YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    Corporate Info
    ABOUT US
    OUR NETWORK
    CONTACT US
    SITE MAP
    UNIX Web Hosting | Merchant Accounts | Dedicated Hosting | E-Commerce Hosting
    Domain Registration | About Us | Our Network | Contact Us | Site Map
    Our Partners
    Copyright © 2002 Dyntex Group, Inc. All Rights Reserved
  • Return to Table of Contents
    		•
  • Back to top
    • Web Hosting: Manuals & FAQ's
    1. Unix-Based Web Hosting
    2. Unix Dedicated Servers
    3. Windows Dedicated Servers
    4. CuteFTP User’s Guide
    5. CuteHTML User’s Guide
    6. WS_FTP Pro User's Guide
    7. Miva Order User's Guide
    8. Miva Merchant User's Guide