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 2757
FindProduct 2863
CreateCart 706
AddProductToCart 1432
Checkout 177
RateProduct 96

Summary

Backend Total Time Wall Time Transport
bonsaidb-local 3.585s 3.585s None
bonsaidb-local+lz4 3.599s 3.599s TCP
bonsaidb-quic 7.016s 7.016s UDP with TLS
bonsaidb-ws 5.886s 5.886s TCP
postgresql 3.663s 3.663s 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 31.09ms 31.09ms 31.09ms 0s 0
bonsaidb-local+lz4 38.81ms 38.81ms 38.81ms 0s 0
bonsaidb-quic 35.39ms 35.39ms 35.39ms 0s 0
bonsaidb-ws 33.01ms 33.01ms 33.01ms 0s 0
postgresql 292.8ms 292.8ms 292.8ms 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 2757 time(s) across each backend.

Backend Avg Min Max StdDev Outliers
bonsaidb-local 83.86us 62.30us 388.5us 11.79us 14
bonsaidb-local+lz4 84.61us 63.45us 244.1us 10.03us 11
bonsaidb-quic 478.1us 303.0us 3.181ms 61.11us 7
bonsaidb-ws 336.4us 251.9us 1.157ms 34.55us 17
postgresql 285.0us 226.2us 8.089ms 156.7us 2
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 2863 time(s) across each backend.

Backend Avg Min Max StdDev Outliers
bonsaidb-local 144.7us 94.31us 1.336ms 38.83us 6
bonsaidb-local+lz4 146.8us 95.54us 1.898ms 44.91us 3
bonsaidb-quic 751.5us 472.6us 3.351ms 80.65us 14
bonsaidb-ws 536.6us 415.7us 2.164ms 70.50us 12
postgresql 322.3us 239.9us 1.412ms 71.63us 88
CreateCart

Measures the time spent creating a shopping cart.

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

Backend Avg Min Max StdDev Outliers
bonsaidb-local 1.047ms 630.1us 5.569ms 440.6us 12
bonsaidb-local+lz4 1.042ms 627.8us 13.46ms 593.7us 6
bonsaidb-quic 1.153ms 810.7us 9.756ms 601.6us 10
bonsaidb-ws 1.124ms 787.7us 5.403ms 356.1us 14
postgresql 630.6us 506.4us 2.420ms 140.1us 10
AddProductToCart

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

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

Backend Avg Min Max StdDev Outliers
bonsaidb-local 1.089ms 660.9us 15.83ms 552.5us 17
bonsaidb-local+lz4 1.094ms 667.1us 9.805ms 483.2us 18
bonsaidb-quic 1.384ms 978.6us 10.43ms 530.9us 24
bonsaidb-ws 1.319ms 900.6us 5.634ms 388.8us 27
postgresql 619.0us 481.7us 5.481ms 226.5us 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 2.056ms 1.436ms 6.059ms 518.3us 3
bonsaidb-local+lz4 2.095ms 1.403ms 3.883ms 489.6us 4
bonsaidb-quic 2.547ms 1.896ms 7.324ms 818.4us 6
bonsaidb-ws 2.491ms 1.811ms 7.287ms 722.8us 5
postgresql 940.8us 762.9us 2.060ms 143.6us 4
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 96 time(s) across each backend.

Backend Avg Min Max StdDev Outliers
bonsaidb-local 2.564ms 1.668ms 7.276ms 982.1us 4
bonsaidb-local+lz4 2.435ms 1.757ms 4.238ms 436.7us 2
bonsaidb-quic 2.745ms 2.061ms 7.388ms 817.7us 4
bonsaidb-ws 2.768ms 1.916ms 6.700ms 742.2us 2
postgresql 1.708ms 1.465ms 4.809ms 342.2us 1