#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Kuwait
    Posts
    47
    Rep Power
    15
    How fast is MySQL when it comes to selecting, inserting or updating a table with millions of records, say over 3 million?

    Thanks.
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    13
    Rep Power
    0
    There is a benchmark result included in the mySQL manual. Reading 2000000 rows by index is 367 second on a NT machine. Didn't say what configuration for the computer, though.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Kuwait
    Posts
    47
    Rep Power
    15
    I saw that benchmark right after I posted my question. I wonder if anyone has a first hand experience with it.

    Do you know how it stacks against Oracle?

    Thanks

  6. #4
  7. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    29
    Rep Power
    0
    I'm a long time Oracle person fairly new to MySQL but my subjective opinion is that MySQL is a lot faster than Oracle. The main reason for this is that Oracle is considerably bloated, and hence slowed, by all the inbuilt referential integrity, rollbacks, database procedures etc.

    I've got a 1.7 million row MySQL table and a query on the primary key column takes about 0.25 seconds.

    As always, with either database, indexing (or not) is the key to performance.

Similar Threads

  1. Getting data from different tables in Mysql with PHP
    By Bosw8er in forum PHP Development
    Replies: 3
    Last Post: February 10th, 2004, 05:25 PM
  2. MySQL lock tables problem: mysql hangs?
    By Cyclefreak in forum MySQL Help
    Replies: 0
    Last Post: February 6th, 2004, 08:24 AM
  3. tranfer tables from mysql to postgresql in linux
    By muthayalap in forum Java Help
    Replies: 0
    Last Post: February 3rd, 2004, 11:13 AM
  4. MySQL tables location
    By RodrigoRosa in forum MySQL Help
    Replies: 8
    Last Post: January 28th, 2004, 08:05 PM
  5. Build HTML tables with multiple mySQL queries
    By SailFan in forum PHP Development
    Replies: 5
    Last Post: January 19th, 2004, 12:25 PM

IMN logo majestic logo threadwatch logo seochat tools logo