HAKOM PowerTSM® Documentation
3.11.3.2 3.11.3.1 3.11.3.0 3.11.2.3 3.11.2.2 3.11.2.1 3.11.2 3.11.1 3.11.0.1 3.11.0 3.10.6.6 3.10.6.5 3.10.6.4 3.10.6.3 3.10.6.2 3.10.6.1 3.10.5.5 3.10.5.4 3.10.5.1 3.10.4.7 3.10.3 3.10.2.2 3.10.1.1 3.10.0 3.9.2.12 English Deutsch
HAKOM PowerTSM® Documentation
3.11.3.2 3.11.3.1 3.11.3.0 3.11.2.3 3.11.2.2 3.11.2.1 3.11.2 3.11.1 3.11.0.1 3.11.0 3.10.6.6 3.10.6.5 3.10.6.4 3.10.6.3 3.10.6.2 3.10.6.1 3.10.5.5 3.10.5.4 3.10.5.1 3.10.4.7 3.10.3 3.10.2.2 3.10.1.1 3.10.0 3.9.2.12 English Deutsch
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)