2

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 ?

dimitris93
  • 4,155
  • 11
  • 50
  • 86

1 Answers1

2

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.

Speerian
  • 1,138
  • 1
  • 12
  • 29