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 :
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.
500K records taking more than one hour to be insered in HDD? I smell something wrong there, but can’t comment with just so few information.