SQLite Database Speed Comparison
SQLite Database Speed Comparison
Database Speed Comparison
Note: This document is very very old. It describes a speed comparison between archaic versions of SQLite, MySQL and PostgreSQL.The numbers here have become meaningless. This page has been retained only as an historical artifact.
Executive Summary
A series of tests were run to measure the relative performance of SQLite 2.7.6, PostgreSQL 7.1.3, and MySQL 3.23.41. The following are general conclusions drawn from these experiments:
SQLite 2.7.6 is significantly faster (sometimes as much as 10 or 20 times faster) than the default PostgreSQL 7.1.3 installation on RedHat 7.2 for most common operations.
SQLite 2.7.6 is often faster (sometimes more than twice as fast) than MySQL 3.23.41 for most common operations.
SQLite does not execute CREATE INDEX or DROP TABLE as fast as the other databases.
