IDE,SCSI,SSD,SATA or all of those.
-
cache my data in a temporary file or MySQL memory db? – lovespring Sep 03 '09 at 04:33
6 Answers
I'm surprised: Figure 3 in the middle of this article, The Pathologies of Big Data, says that memory is only about 6 times faster when you're doing sequential access (350 Mvalues/sec for memory compared with 58 Mvalues/sec for disk); but it's about 100,000 times faster when you're doing random access.

- 54,973
- 13
- 116
- 224
-
1Which is one reason that Vista introduced ReadyBoost... even though sequential access on a flash drive is much slower than a hard drive, there are no mechanical, moving parts on the flash drive so random access is just as fast as sequential access. – Eric J. Sep 03 '09 at 04:31
-
The link I cited said their test was using a freshly-booted machine, to avoid measuring any O/S caching. – ChrisW Sep 03 '09 at 04:36
-
"on the flash drive random access is just as fast as sequential access" -- the link I cited says that it's 10,000 times slower. – ChrisW Sep 03 '09 at 04:50
-
Erhm, I don't know how they tested this exactly, but RAM access in my system is in excess of 26 GB/s, 19 times faster than mentioned here. Also, the tested disks are not exactly a typical setup, unless we're talking servers specifically. – Thorarin Sep 03 '09 at 05:06
-
http://www.tomshardware.com/picturestory/511-4-memory-scaling-ddr3.html says about 100 GB/sec for DDR3 memory. That ACM article was measuring on a server with 64 GB RAM (so I suppose possibly not the fastest/most expensive type of RAM). – ChrisW Sep 03 '09 at 05:18
-
1I don't know about 100 GB/s... I have 1800 MHz DDR3 after all. Still, it's a huge difference. To be fair, my sequential disk access is slightly faster than these figures as well, but only by a small amount (270 MB/s or so) – Thorarin Sep 03 '09 at 05:58
-
2The link is five years old, but wow. If this is accurate its probably the least understood characteristic of computers. – OneSolitaryNoob Feb 22 '14 at 21:55
-
Random vs. sequential access is a crucially important distinction here. Even sequential disk access is faster than random RAM access. This highlights the difference between latency and throughput. Sadly, this topic is not widely understood. It should also be noted that CPU registers are between 1 and 1,000 million times faster than some of the fastest SSDs. – BMiner Apr 02 '21 at 18:41
Random Access Memory (RAM) takes nanoseconds to read from or write to, while hard drive (IDE, SCSI, SATA that I'm aware of) access speed is measured in milliseconds.

- 325,700
- 82
- 523
- 502
2016 Hardware Update: Actual read/write seq throughput
Now the Samsung 940 PRO SSD
- reading at 3,500 MB/sec
- writing at 2,100 MB/sec
- reading at 61,000 MB/sec
- writing at 48,000 MB/sec..
So now using this metric, RAM looks to be 20x faster than the stuff around when @ChrisW wrote his answer, not 100,000. And, SSDs are 10 times faster than RAM was when he wrote this question.
An important consideration is that we're only measuring memory bandwidth not latency.

- 78,363
- 46
- 261
- 468
It's not precisely about SCSI drives, but I think that the Latency Numbers Every Programmer Should Know table could assist you in understanding the speed and the difference between different latency numbers, including storage options.
Latency Comparison Numbers (~2012)
----------------------------------
L1 cache reference 0.5 ns
Branch mispredict 5 ns
L2 cache reference 7 ns 14x L1 cache
Mutex lock/unlock 25 ns
Main memory reference 100 ns 20x L2 cache, 200x L1 cache
Compress 1K bytes with Zippy 3,000 ns 3 us
Send 1K bytes over 1 Gbps network 10,000 ns 10 us
Read 4K randomly from SSD* 150,000 ns 150 us ~1GB/sec SSD
Read 1 MB sequentially from memory 250,000 ns 250 us
Round trip within same datacenter 500,000 ns 500 us
Read 1 MB sequentially from SSD* 1,000,000 ns 1,000 us 1 ms ~1GB/sec SSD, 4X memory
Disk seek 10,000,000 ns 10,000 us 10 ms 20x datacenter roundtrip
Read 1 MB sequentially from disk 20,000,000 ns 20,000 us 20 ms 80x memory, 20X SSD
Send packet CA->Netherlands->CA 150,000,000 ns 150,000 us 150 ms
Here is a great visual representation that will help you to better understand the scale: https://people.eecs.berkeley.edu/~rcs/research/interactive_latency.html

- 14,397
- 15
- 77
- 118
RAM is 100 Thousand Times Faster than Disk for Database Access from http://www.directionsmag.com/articles/ram-is-100-thousand-times-faster-than-disk-for-database-access/123964

- 91
- 1
- 1
Accessing the RAM is in the order of nanoseconds ( 10e-9 seconds ), while accessing data on the disk or the network is in the order of milliseconds (10e-3 seconds).
from Node.JS Design Patterns

- 853
- 11
- 16