Benchmark Comparison
This benchmark compares sqlalchemy-memory to in-memory SQLite using 20,000 inserted items and a series of 500 queries, updates, and deletions.
As the results show, sqlalchemy-memory excels in read-heavy workloads, delivering significantly faster query performance. While SQLite performs slightly better on update and delete operations, the overall runtime of sqlalchemy-memory remains substantially lower, making it a strong choice for prototyping and simulation.
Check the benchmark script on GitHub
Operation |
SQLite (in-memory) |
sqlalchemy-memory |
|---|---|---|
Insert |
3.30 sec |
3.10 sec |
500 Select Queries (all()) |
30.07 sec |
4.14 sec |
500 Select Queries (limit(5)) |
0.24 sec |
0.30 sec |
500 Updates |
0.25 sec |
0.19 sec |
500 Deletes |
0.09 sec |
0.09 sec |
Total Runtime |
33.95 sec |
7.81 sec |