Menu

WJb Persistent Storage Benchmark: SQLite vs SQL Server
📰

WJb Persistent Storage Benchmark: SQLite vs SQL Server

DEV Community: dotnet·Oleksandr Viktor·15 days ago
#HMAr29gu
#devtodotnet#devto#dev#sqlite#storage
Reading 0:00
15s threshold

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 .…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.