WJb Persistent Storage Benchmark: SQLite vs SQL Server
WJb is a lightweight, explicit workflow and background job engine for .NET. One of its key strengths is storage-agnostic design: jobs can be persisted through different providers while keeping the same programming model.
This article examines the Persistent Storage Benchmark from the WJb.Demo repository . The benchmark compares two commercial storage providers:
WJb.SQLite — embedded, file-based storage
WJb.SqlServer — full SQL Server / LocalDB storage
Benchmark Scenario
The test measures a complete enqueue → dequeue cycle:
Enqueue N jobs (each with a simple payload)
Dequeue every job until the queue is empty
Verify that the number of processed jobs matches the number enqueued
This is a pure storage throughput test. No real job execution logic is involved beyond the store operations themselves.
Code Overview
The benchmark is implemented with BenchmarkDotNet and targets .NET 10:
[ SimpleJob ( RuntimeMoniker .…