BonsaiDb Commerce Benchmark

small, writeheavy, 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 2753
FindProduct 2883
CreateCart 988
AddProductToCart 5050
Checkout 894
RateProduct 4143

Summary

Backend Total Time Wall Time Transport
bonsaidb-local 5.443s 5.443s None
bonsaidb-local+lz4 6.250s 6.250s TCP
bonsaidb-quic 12.54s 12.54s UDP with TLS
bonsaidb-ws 11.08s 11.08s TCP
postgresql 32.19s 32.19s 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 16.95ms 16.95ms 16.95ms 0s 0
bonsaidb-local+lz4 15.20ms 15.20ms 15.20ms 0s 0
bonsaidb-quic 14.04ms 14.04ms 14.04ms 0s 0
bonsaidb-ws 12.52ms 12.52ms 12.52ms 0s 0
postgresql 443.2ms 443.2ms 443.2ms 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 2753 time(s) across each backend.

Backend Avg Min Max StdDev Outliers
bonsaidb-local 89.65us 39.90us 994.8us 46.43us 29
bonsaidb-local+lz4 112.8us 45.40us 3.271ms 108.9us 28
bonsaidb-quic 468.8us 337.4us 7.361ms 285.0us 31
bonsaidb-ws 405.5us 242.3us 6.296ms 220.7us 30
postgresql 833.5us 365.1us 9.178ms 498.4us 32
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 2883 time(s) across each backend.

Backend Avg Min Max StdDev Outliers
bonsaidb-local 223.4us 54.30us 4.069ms 175.7us 30
bonsaidb-local+lz4 240.2us 76.00us 10.12ms 257.7us 16
bonsaidb-quic 637.7us 393.1us 10.89ms 353.7us 42
bonsaidb-ws 550.4us 301.9us 11.09ms 319.1us 34
postgresql 948.2us 411.5us 30.53ms 882.9us 19
CreateCart

Measures the time spent creating a shopping cart.

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

Backend Avg Min Max StdDev Outliers
bonsaidb-local 196.8us 76.20us 4.676ms 220.6us 10
bonsaidb-local+lz4 217.3us 124.7us 3.990ms 197.0us 8
bonsaidb-quic 407.8us 288.4us 2.894ms 193.2us 19
bonsaidb-ws 352.1us 216.0us 2.097ms 162.9us 23
postgresql 1.456ms 906.1us 14.51ms 1.204ms 21
AddProductToCart

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

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

Backend Avg Min Max StdDev Outliers
bonsaidb-local 244.8us 97.10us 7.208ms 224.2us 36
bonsaidb-local+lz4 281.1us 144.5us 10.36ms 343.8us 38
bonsaidb-quic 658.9us 480.3us 8.437ms 389.5us 57
bonsaidb-ws 591.3us 332.7us 12.41ms 438.8us 49
postgresql 1.359ms 820.0us 28.45ms 1.208ms 86
Checkout

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

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

Backend Avg Min Max StdDev Outliers
bonsaidb-local 422.7us 162.7us 8.756ms 372.3us 9
bonsaidb-local+lz4 452.3us 245.8us 2.966ms 197.7us 16
bonsaidb-quic 1.069ms 772.1us 7.386ms 512.6us 14
bonsaidb-ws 951.5us 535.9us 18.61ms 720.1us 6
postgresql 1.501ms 837.7us 10.37ms 688.3us 14
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 4143 time(s) across each backend.

Backend Avg Min Max StdDev Outliers
bonsaidb-local 658.1us 316.8us 15.08ms 414.6us 39
bonsaidb-local+lz4 770.6us 390.6us 13.19ms 627.7us 45
bonsaidb-quic 1.137ms 793.1us 18.03ms 634.1us 38
bonsaidb-ws 1.009ms 624.5us 16.65ms 606.4us 44
postgresql 4.122ms 2.562ms 102.8ms 2.570ms 48