Skip to main content

    Database Performance Reference

    Database characteristics, query patterns, and optimization strategies

    Database Performance Characteristics

    Compare latency, throughput, and scalability

    Redis

    In-Memory Cache

    Read Latency

    < 1 ms

    Write Latency

    < 1 ms

    Max QPS

    1M+

    Consistency

    Eventual

    Scalability

    Horizontal (Cluster)

    Best For

    Caching, Session Store, Pub/Sub

    PostgreSQL

    RDBMS

    Read Latency

    1-10 ms

    Write Latency

    5-20 ms

    Max QPS

    50K

    Consistency

    ACID

    Scalability

    Vertical + Read Replicas

    Best For

    Transactional, Complex Queries

    MongoDB

    Document Store

    Read Latency

    1-10 ms

    Write Latency

    5-15 ms

    Max QPS

    100K

    Consistency

    Tunable

    Scalability

    Horizontal (Sharding)

    Best For

    Flexible Schema, JSON Documents

    Cassandra

    Wide Column Store

    Read Latency

    5-20 ms

    Write Latency

    2-10 ms

    Max QPS

    1M+

    Consistency

    Eventual/Tunable

    Scalability

    Linear Horizontal

    Best For

    Time Series, High Write Volume

    DynamoDB

    Key-Value Store

    Read Latency

    < 10 ms

    Write Latency

    < 10 ms

    Max QPS

    Unlimited*

    Consistency

    Eventual/Strong

    Scalability

    Auto-scaling

    Best For

    Serverless, Simple Queries

    Elasticsearch

    Search Engine

    Read Latency

    10-100 ms

    Write Latency

    50-200 ms

    Max QPS

    10K

    Consistency

    Eventual

    Scalability

    Horizontal (Cluster)

    Best For

    Full-text Search, Analytics

    Key Trade-offs