Performance Benchmarks

Real-world performance metrics of GuusLab Core's Rust-powered SQLite database

Key Performance Metrics

800ms
1M Row Insert
Incl. network request
40ms
Avg Query Time
Complex SELECT queries
1Gb/s
Upload Speed
File uploads to buckets
<5ms
API Response
Simple CRUD operations

Detailed Benchmarks

Database Operations

Single INSERT0.8ms
Bulk INSERT (1000 rows)45ms
Bulk INSERT (1M rows)800ms
Simple SELECT2ms
Complex JOIN query40ms
Index creation120ms

API Performance

GET /api/tables3ms
POST /api/tables8ms
GET /api/tables/:id/rows12ms
POST /api/tables/:id/rows5ms
WebSocket connection1ms
JWT verification0.3ms

Resource Usage

CPU Usage

Idle0.1%
Light load2-5%
Heavy queries15-25%

Memory Usage

Base runtime8MB
Per database2-4MB
Cache overhead10-20MB

Throughput

Simple queries500/sec
Insert operations200/sec
Concurrent users100+

Test Environment

Hardware Specifications

CPU
Apple M4 (10-core)
Memory
32GB Unified Memory
Storage
512GB SSD
Internet
1GB/s connection
OS
macOS Sequoia 15.5
Rust Version
1.85.1
SQLite Version
3.44.2
Rusqlite Version
0.31.0

Experience the Performance

Test these benchmarks yourself with your own data. Start for free and see the difference.

Start Testing