SQLITE TRANSACTION PERFORMANCE SERIES

Note in particular the default MySQL configuration on RedHat 7.2 does not support transactions. (PostgreSQL version 7.1.3 and MySQL version 3.23.41.) No effort was made to tune these engines. The PostgreSQL and MySQL servers used were as delivered by default on RedHat 7.2. The operating system is RedHat Linux 7.2 with a stock kernel. The platform used for these tests is a 1.6GHz Athlon with 1GB or memory and an IDE disk drive. They do not measure how well the database engines scale to larger problems. These tests are on a relatively small (approximately 14 megabyte) database. These tests did not attempt to measure multi-user performance or optimization of complex queries involving multiple joins and subqueries. The results presented here come with the following caveats: SQLite works best if you group multiple operations together into a single transaction. But this is not seen as a problem because those are infrequent operations. SQLite does not execute CREATE INDEX or DROP TABLE as fast as the other databases. SQLite 2.7.6 is often faster (sometimes more than twice as fast) than MySQL 3.23.41 for most common operations.

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. The following are general conclusions drawn from these experiments:

SQLITE TRANSACTION PERFORMANCE SERIES

Executive SummaryĪ series of tests were run to measure the relative performance of SQLite 2.7.6, PostgreSQL 7.1.3, and MySQL 3.23.41. This page has been retained only as an historical artifact. The numbers here have become meaningless. It describes a speed comparison between archaic versions of SQLite, MySQL and PostgreSQL. SQLite Database Speed Comparison Database Speed Comparison Note: This document is very very old.

Sqlite transaction performance