BonsaiDb Commerce Benchmark

small, balanced, 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 2768
FindProduct 2860
CreateCart 708
AddProductToCart 1436
Checkout 177
RateProduct 95

Summary

Backend Total Time Wall Time Transport
bonsaidb-local 1.508s 1.508s None
bonsaidb-local+lz4 1.237s 1.237s TCP
bonsaidb-quic 4.386s 4.386s UDP with TLS
bonsaidb-ws 3.675s 3.675s TCP
postgresql 7.289s 7.289s 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 10.10ms 10.10ms 10.10ms 0s 0
bonsaidb-local+lz4 10.72ms 10.72ms 10.72ms 0s 0
bonsaidb-quic 14.65ms 14.65ms 14.65ms 0s 0
bonsaidb-ws 13.18ms 13.18ms 13.18ms 0s 0
postgresql 486.1ms 486.1ms 486.1ms 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 2768 time(s) across each backend.

Backend Avg Min Max StdDev Outliers
bonsaidb-local 102.8us 35.40us 8.868ms 329.0us 19
bonsaidb-local+lz4 75.90us 37.70us 4.555ms 104.7us 22
bonsaidb-quic 442.3us 325.2us 5.592ms 206.7us 36
bonsaidb-ws 366.4us 221.7us 8.976ms 247.2us 24
postgresql 630.2us 336.4us 26.80ms 739.9us 17
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 2860 time(s) across each backend.

Backend Avg Min Max StdDev Outliers
bonsaidb-local 162.9us 57.20us 4.724ms 233.2us 30
bonsaidb-local+lz4 140.0us 56.60us 10.83ms 252.6us 13
bonsaidb-quic 541.4us 361.1us 11.64ms 328.6us 27
bonsaidb-ws 453.0us 259.2us 9.761ms 353.7us 22
postgresql 656.6us 346.6us 21.59ms 509.0us 14
CreateCart

Measures the time spent creating a shopping cart.

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

Backend Avg Min Max StdDev Outliers
bonsaidb-local 223.2us 103.9us 5.365ms 359.3us 11
bonsaidb-local+lz4 202.2us 109.2us 12.20ms 501.4us 4
bonsaidb-quic 461.6us 271.1us 11.36ms 607.3us 9
bonsaidb-ws 359.1us 221.8us 8.339ms 380.6us 8
postgresql 1.298ms 873.7us 19.44ms 1.145ms 6
AddProductToCart

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

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

Backend Avg Min Max StdDev Outliers
bonsaidb-local 290.5us 138.7us 8.532ms 388.8us 24
bonsaidb-local+lz4 237.0us 143.0us 2.096ms 109.5us 26
bonsaidb-quic 674.9us 459.8us 9.710ms 467.6us 18
bonsaidb-ws 585.2us 360.0us 5.487ms 356.7us 21
postgresql 1.170ms 832.5us 15.70ms 698.6us 15
Checkout

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

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

Backend Avg Min Max StdDev Outliers
bonsaidb-local 472.6us 278.8us 5.090ms 453.3us 4
bonsaidb-local+lz4 391.4us 247.3us 1.396ms 145.3us 5
bonsaidb-quic 1.044ms 833.5us 9.211ms 672.5us 2
bonsaidb-ws 923.4us 717.0us 4.058ms 414.8us 4
postgresql 1.376ms 912.6us 7.611ms 735.7us 3
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 95 time(s) across each backend.

Backend Avg Min Max StdDev Outliers
bonsaidb-local 934.9us 482.4us 5.600ms 993.2us 5
bonsaidb-local+lz4 662.4us 477.0us 2.771ms 310.1us 2
bonsaidb-quic 1.241ms 820.8us 14.13ms 1.368ms 1
bonsaidb-ws 992.5us 730.5us 8.432ms 810.9us 1
postgresql 3.553ms 2.814ms 8.327ms 733.3us 1