News for hackers. Stuff that matters.
Re:Data Warehouse vs. Operational Database What? How? Which ... by swyx on Monday December 19, 2022 @10:18AM (#34053033)
> For example, loading data from an SSD is more than 3 orders of magnitude (more than 1000x) slower than referencing main memory, and a disk seek on a spinning disk is 5 orders of magnitude (100,000x) slower than referencing data that is in memory. The above latencies should make it clear that there is a huge performance advantage to minimizing disk access.

this is the first explanation i've seen that directly links disk latency and data architecture decisions. always felt it intuitively but never did the math.

There are no comments on this comment yet.