BonsaiDb Commerce Benchmark

small, readheavy, 1 agent(s)

Configuration

Initial Data Set
Type Count
Products 100
Categories 10
Customers 100
Orders 125
Shopping Plans

This run executed 1000 shopping plans across 1 worker(s). All total, the workers will execute the following breakdown of operations:

Operation Invocations
Load 1
LookupProduct 2764
FindProduct 2872
CreateCart 435
AddProductToCart 592
Checkout 38
RateProduct 5

Summary

Backend Total Time Wall Time Transport
bonsaidb-local 1.728s 1.728s None
bonsaidb-local+lz4 1.789s 1.789s TCP
bonsaidb-quic 5.195s 5.195s UDP with TLS
bonsaidb-ws 3.856s 3.856s TCP
postgresql 2.634s 2.634s TCP
Table of Contents:

Operation Results

Load

Measures the time spent loading the initial data set and performing any pre-cache operations that most database administrators would perform on their databases periodically to ensure good performance.

This operation was executed 1 time(s) across each backend.

Backend Avg Min Max StdDev Outliers
bonsaidb-local 32.12ms 32.12ms 32.12ms 0s 0
bonsaidb-local+lz4 31.36ms 31.36ms 31.36ms 0s 0
bonsaidb-quic 36.26ms 36.26ms 36.26ms 0s 0
bonsaidb-ws 34.01ms 34.01ms 34.01ms 0s 0
postgresql 286.9ms 286.9ms 286.9ms 0s 0
LookupProduct

Meaures the time spent looking up a product by its id. This operation is meant to simulate the basic needs of the database to provide a product details page after a user clicked a direct link that contians the product's unique id, including the product's current rating.

This operation was executed 2764 time(s) across each backend.

Backend Avg Min Max StdDev Outliers
bonsaidb-local 82.54us 62.60us 381.7us 9.868us 10
bonsaidb-local+lz4 83.74us 63.76us 133.2us 6.940us 25
bonsaidb-quic 476.8us 329.3us 650.8us 22.11us 41
bonsaidb-ws 333.1us 273.5us 851.4us 22.68us 27
postgresql 275.0us 222.4us 624.7us 31.26us 25
FindProduct

Measures the time spent looking up a product by its name (exact match, indexed). This operation is meant to simulate the basic needs of the database to provide a product details after finding a product by its name, including the product's current rating.

This operation was executed 2872 time(s) across each backend.

Backend Avg Min Max StdDev Outliers
bonsaidb-local 133.9us 94.74us 2.427ms 49.07us 2
bonsaidb-local+lz4 136.8us 96.17us 3.639ms 69.24us 2
bonsaidb-quic 741.8us 507.0us 4.837ms 87.33us 3
bonsaidb-ws 518.9us 427.3us 2.434ms 51.87us 10
postgresql 298.5us 237.3us 1.836ms 49.26us 29
CreateCart

Measures the time spent creating a shopping cart.

This operation was executed 435 time(s) across each backend.

Backend Avg Min Max StdDev Outliers
bonsaidb-local 965.3us 644.2us 5.398ms 408.6us 7
bonsaidb-local+lz4 1.007ms 637.4us 5.200ms 323.1us 5
bonsaidb-quic 1.375ms 864.9us 5.060ms 384.0us 6
bonsaidb-ws 1.159ms 819.6us 5.344ms 314.8us 5
postgresql 676.7us 515.3us 4.603ms 232.0us 2
AddProductToCart

Measures the time spent adding a product to a shopping cart.

This operation was executed 592 time(s) across each backend.

Backend Avg Min Max StdDev Outliers
bonsaidb-local 975.7us 684.2us 5.092ms 305.6us 5
bonsaidb-local+lz4 1.029ms 719.1us 4.345ms 300.4us 8
bonsaidb-quic 1.643ms 1.049ms 6.230ms 492.5us 11
bonsaidb-ws 1.332ms 919.2us 9.466ms 418.6us 4
postgresql 650.0us 489.8us 1.603ms 121.7us 14
Checkout

Measures the time spent converting a shopping cart into an order for a customer.

This operation was executed 38 time(s) across each backend.

Backend Avg Min Max StdDev Outliers
bonsaidb-local 1.906ms 1.437ms 2.615ms 260.3us 0
bonsaidb-local+lz4 1.964ms 1.510ms 3.930ms 396.4us 1
bonsaidb-quic 3.154ms 2.174ms 8.025ms 968.3us 1
bonsaidb-ws 2.678ms 1.996ms 7.111ms 1.049ms 1
postgresql 1.045ms 759.1us 2.027ms 243.5us 1
RateProduct

Measures the time spent adding or updating a review of a product by a customer. Each customer can only have one review per product. When this operation is complete, all subsequent calls to LookupProduct and FindProduct should reflect the new rating. This simulates an 'upsert' (insert or update) operation using a unique index.

This operation was executed 5 time(s) across each backend.

Backend Avg Min Max StdDev Outliers
bonsaidb-local 2.666ms 2.222ms 3.086ms 338.6us 0
bonsaidb-local+lz4 2.378ms 2.185ms 2.579ms 140.7us 0
bonsaidb-quic 3.896ms 2.740ms 5.109ms 873.8us 0
bonsaidb-ws 3.319ms 2.208ms 6.863ms 1.779ms 0
postgresql 2.122ms 1.740ms 2.297ms 203.3us 0