3 ms·
Below is some interesting speed benchmarking. "A series of tests were run to measure the relative performance of SQLite 2.7.6, PostgreSQL 7.1.3, and MySQL 3.23
by oli5679 4y ago
Below is some interesting speed benchmarking.
"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. But this is not seen as a problem because those are infrequent operations.
SQLite works best if you group multiple operations together into a single transaction."
https://www.sqlite.org/speed.html https://www.sqlite.org/speed.html
- banana_giraffe 4y agoInteresting, to a small point: > 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. For some context, this page represents the state of things nearly 20 years ago.
- Groxx 4y agoFor single machine workloads, it's probably still largely true. Though so sensitive to details that it's not a particularly useful benchmark. SQLite is often literally unbelievably fast for many operations, and having it operating in the same process gives it a substantially lower minimum that separate dedicated processes can't compete with. But it's not really designed to do things asynchronously (e.g. no background optimizing while idle), or as-efficiently for very large (or strange) operations. Simpler caches and indexes, more straightforward behavior, etc.
- deleted 4y ago[deleted]