posted on Saturday, August 27, 2005 7:47 AM
by
stefandemetz
Latest TPC-C is a scam
I recently had a look at the no.1 on the TPC, which is amost 3 times as fast as the other ones.
I don't doubt that IBM is up there with the best, but the amounts of RAM and disks
compared to the others was a bit cheating. Why?
Because it has almost twice as much RAM as the DB files(s).
The DBs for the TPC are around 1 TB:
while MS and Oracle competed with 1 TB for the top spot, IBM had 2 TB.
What does it mean having THAT more RAM?
That besides having the DB file(s) in RAM,
having ALL temporary(e.g. old AND new data pages) data in RAM,
plus all OS in RAM,
plus any other code to help out the DB.
By avoiding to touch the disks for that extra 1 TB the performance is obviously superior.
Just recount that RAM is at least 40 times faster than disk persistence.