Search code examples
olapsolid-state-driveoltp

SSD performance benefit in OLTP vs OLAP

In which system is SSD disk better over HDD as far as performance is concerned ? An OLTP or an OLAP system ?

My guess is that in OLTP an SSD disk is more valuable, because transactions are constantly occurring and we need the non-sequential read-write speeds. Is this correct ?

Solution

  • I'm not experienced with the two systems, but from what I know I would say that an SSD would be most beneficent for a OLTP system. Since OLAP is focused more upon complex queries involving aggregation, I'd be inclined to think that read-write times would not be the limiting factor for an OLAP system. That's my two-cents.

    You can read more here.

    Hope this helps.