HAKOM PowerTSM® Documentation
HAKOM PowerTSM® Documentation
Breadcrumbs

Relational vs. Horizontally Scalable Databases

The following table shows a comparison between three database technologies in terms of read and write performance.

DB

Typ

Performance

image2021-3-15_17-39-54.png

Horizontally Scalable

  • Ingestion:     50.000 Values/sec (1 DB Node, 1 App Server) linear scaling

  • Latency of Realtime queries:     < 1 sec

  • Latency of agg. Queries:              < 2 sec

  • Read: 150.000 Values/sec (1 DB Node, 1 App Server)

image2021-3-15_17-41-12.png

Horizontally Scalable

  • Ingestion:           350.000 Values/sec (2 DB Nodes, 4 App Server) linear scaling

  • Read: 250.000 Values/sec (2 DB Nodes, 4 App Server)

image2021-3-15_17-40-11.png

Relational

  • Ingestion:           420.000 Values/sec (1 DB Nodes, 2 App Server) not scaling

  • Read:    1.080.000 Values/sec (1 DB Node, 2 App Server)