Tables
Select a database to view tables
Browse
Structure
SQL
Search
Insert
Export
Import
Triggers
Views
⚡ Performance
Select a table to browse data
Select a table to view structure
SQL Query
Run a query to see results
Advanced Search
Insert New Row
Export
Import
Click to select file
Triggers
Views
⚡ Performance Optimization
SQLite Version: 3.7.17 - WAL mode and all performance PRAGMAs below are supported!
~
Write Speed
~
Read Speed
~
Data Safety
Journal Mode (Write-Ahead Logging)
PRAGMA journal_mode
WAL = faster writes, better concurrency
Synchronization (fsync)
PRAGMA synchronous
OFF = 50x faster writes but risk of corruption on power loss
Cache Size
PRAGMA cache_size
pages (~1KB each)
Larger cache = less disk I/O, more memory usage
Temporary Storage
PRAGMA temp_store
MEMORY stores temp tables in RAM for speed
Memory-Mapped I/O
PRAGMA mmap_size
bytes (0 = disabled)
Maps database into memory for faster reads
Auto-Vacuum
PRAGMA auto_vacuum
Automatically reclaim space when data is deleted
Page Size
PRAGMA page_size
Larger pages = better for large databases (can only be set before creating tables)
⚡ Maximum Speed Configuration (Danger Zone):
🚀 Balanced Configuration (Recommended):
PRAGMA journal_mode = MEMORY;
PRAGMA synchronous = OFF;
PRAGMA cache_size = 100000;
PRAGMA temp_store = MEMORY;
🚀 Balanced Configuration (Recommended):
PRAGMA journal_mode = WAL;
PRAGMA synchronous = NORMAL;
PRAGMA cache_size = 10000;
PRAGMA temp_store = MEMORY;