Firebird 2.1.3 #HDD vs #SSD Benchmarks

The forum post with the results are in Spanish but here are the results and translation in English:
1. The computer was as below :

  • Intel Core i7 930 2.93 @ 4.0 Ghz
  • 6GB DDR3 1600 Cas 7
  • Mobo Gigabyte x58-UD3R
  • Professional 64-bit Windows 7
  • Firebird 2.1.3
  • 2. Hard Drives :
    a. Western Digital 1TB 64MB Cache Sata III Black
    b. Crucial 128GB RealSSD C300

    The test consisted in the creation of a database with 1 table :

    CREATE TABLE COR_PRUEBA (
    INTEGER INTEGER NOT NULL,
    CHARACTER CHAR (20),
    CARACTER2 CHAR (10),
    “DOUBLE” DECIMAL (15, 2),
    INTEGER1 INTEGER);
    ALTER TABLE COR_PRUEBA
    PK_COR_PRUEBA ADD CONSTRAINT PRIMARY KEY (INT);

    The test is done with the IBExpert 2009.08.19 and consisted of the insertion of 500,000 records (Insert operations) with random data.
    Results:

    Disc A (HDD): 1hr 11m 40s 43ms
    Disc B (SSD): 3m 42s 224ms

    What really stunned me was the Big difference and both tests were performed with exactly the same parameters.
    Judge yourself whether it is worth mounting a SSD for storage xD.

    1 Star2 Stars3 Stars4 Stars5 Stars (5 votes, average: 4.20 out of 5)
    Loading...

    One comment

    Leave a Reply