These tests did not attempt to measure multi-user performance or The results presented here come with the following caveats: SQLite works best if you group multiple operations together into But this is not seen as a problem because SQLite does not execute CREATE INDEX or DROP TABLE as fast as More than twice as fast) than MySQL 3.23.41 On RedHat 7.2 for most common operations.
SQLite 2.7.6 is significantly faster (sometimes as much as 10 orĢ0 times faster) than the default PostgreSQL 7.1.3 installation SQLite 2.7.6, PostgreSQL 7.1.3, and MySQL 3.23.41.Ĭonclusions drawn from these experiments: This page has been retained onlyĪ series of tests were run to measure the relative performance of The numbers here have become meaningless. It describes a speed comparison betweenĪrchaic versions of SQLite, MySQL and PostgreSQL.