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 2763
FindProduct 2868
CreateCart 433
AddProductToCart 588
Checkout 38
RateProduct 5

Summary

Backend Total Time Wall Time Transport
bonsaidb-local 790.1ms 790.1ms None
bonsaidb-local+lz4 826.6ms 826.6ms TCP
bonsaidb-quic 3.305s 3.305s UDP with TLS
bonsaidb-ws 2.944s 2.944s TCP
postgresql 4.828s 4.828s 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 9.760ms 9.760ms 9.760ms 0s 0
bonsaidb-local+lz4 11.11ms 11.11ms 11.11ms 0s 0
bonsaidb-quic 15.15ms 15.15ms 15.15ms 0s 0
bonsaidb-ws 13.44ms 13.44ms 13.44ms 0s 0
postgresql 462.4ms 462.4ms 462.4ms 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 2763 time(s) across each backend.

Backend Avg Min Max StdDev Outliers
bonsaidb-local 71.10us 31.50us 810.6us 46.89us 40
bonsaidb-local+lz4 79.98us 34.20us 6.082ms 204.8us 11
bonsaidb-quic 438.7us 315.8us 11.52ms 331.1us 24
bonsaidb-ws 390.6us 209.7us 9.172ms 418.8us 32
postgresql 510.3us 314.7us 8.611ms 322.8us 26
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 2868 time(s) across each backend.

Backend Avg Min Max StdDev Outliers
bonsaidb-local 119.4us 49.40us 6.837ms 168.5us 17
bonsaidb-local+lz4 118.7us 54.40us 9.285ms 217.4us 10
bonsaidb-quic 513.7us 357.8us 9.341ms 321.7us 31
bonsaidb-ws 435.2us 242.9us 5.382ms 250.4us 43
postgresql 557.8us 344.9us 7.934ms 343.3us 30
CreateCart

Measures the time spent creating a shopping cart.

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

Backend Avg Min Max StdDev Outliers
bonsaidb-local 181.9us 109.8us 4.850ms 236.4us 2
bonsaidb-local+lz4 188.6us 113.0us 1.885ms 144.2us 8
bonsaidb-quic 403.0us 276.1us 2.096ms 132.2us 8
bonsaidb-ws 419.1us 222.6us 7.523ms 550.1us 6
postgresql 1.382ms 884.9us 22.73ms 1.248ms 6
AddProductToCart

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

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

Backend Avg Min Max StdDev Outliers
bonsaidb-local 241.6us 162.9us 1.490ms 111.5us 8
bonsaidb-local+lz4 258.4us 164.3us 4.261ms 215.5us 4
bonsaidb-quic 658.3us 457.8us 3.189ms 241.9us 11
bonsaidb-ws 625.6us 352.2us 13.05ms 660.5us 6
postgresql 1.166ms 846.9us 6.849ms 531.0us 11
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 405.8us 282.6us 898.4us 134.0us 2
bonsaidb-local+lz4 391.6us 307.8us 650.4us 78.57us 1
bonsaidb-quic 931.0us 784.5us 1.358ms 100.2us 1
bonsaidb-ws 1.251ms 621.1us 9.575ms 1.514ms 1
postgresql 1.412ms 917.2us 8.847ms 1.273ms 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 1.044ms 530.5us 2.956ms 956.2us 0
bonsaidb-local+lz4 1.104ms 574.5us 3.068ms 982.5us 0
bonsaidb-quic 1.541ms 954.0us 3.355ms 912.7us 0
bonsaidb-ws 1.261ms 872.0us 2.720ms 729.7us 0
postgresql 3.699ms 2.997ms 4.305ms 566.8us 0