SSD performance benefit in OLTP vs OLAP

712 Views Asked by At

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 ?

1

There are 1 best solutions below

1
On BEST ANSWER

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.