#Sqlite vs sql server performance series

The default MySQL configuration on RedHat 7.2 does not support

No effort was made to tune these engines. (PostgreSQL version 7.1.3 and MySQL version 3.23.41.) The PostgreSQL and MySQL servers used were as delivered by default on The operating system is RedHat Linux 7.2 with The platform used for these tests is a 1.6GHz Athlon with 1GB or memoryĪnd 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. Optimization of complex queries involving multiple joins and subqueries. 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:

#Sqlite vs sql server performance series

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.