🦆
ws4sqlite
v0.16
v0.16
  • 🌱Introduction & Credits
  • 🥇Features
    • 🚄Performances
  • 🏫Tutorial
  • 🔦Cheat Sheet
  • 🏗️Building & Testing
  • 🛡️Security
  • 📖Documentation
    • 🔧Installation
      • 🐳Docker
    • 🏃Running
    • 📃Configuration File
    • 🔓Authentication
    • 📦Stored Statements
    • ❓Requests
    • ❗Responses
    • ❌Errors
    • 🔨Scheduled Tasks
    • 🌐Embedded Web Server
  • 💡Client Libraries
  • 🎓Advanced Topics
  • 🪐Integrations
    • ⚙️Reverse Proxy
  • ⚖️License
  • 👷GitHub Repository
  • 🚁Support on Discord
Powered by GitBook
On this page
Edit on GitHub
  1. Features

Performances

This page is quite outdated. New, more complete measurements are needed. Help appreciated ;-)

ws4sqlite v0.9.1 with Apache JMeter. Debian Linux system, Azure Standard B2s (2 vcpus).

Tested with 100, 1000, ... concurrent requests. Single SELECT on a file-based database, by primary key, on a 2000-records table. Fits in cache, WAL mode (not read only).

   100 in 00:00:00 =  221.7/s Avg: 14 Min: 1 Max: 54 Err: 0
  1000 in 00:00:02 =  460.8/s Avg:  2 Min: 0 Max: 42 Err: 0
 10000 in 00:00:12 =  834.1/s Avg:  1 Min: 0 Max: 82 Err: 0
100000 in 00:01:02 = 1621.1/s Avg:  0 Min: 0 Max: 54 Err: 0

Sub-millisecond response time, scales better than linear. Notice that requests to the underlying db are serialized.

PreviousFeaturesNextTutorial

Last updated 1 year ago

🥇
🚄