3 ms·
Why choose sqlite over MySQL on a single server (e.g. small vm instance)?
by tutfbhuf 6y ago
Why choose sqlite over MySQL on a single server (e.g. small vm instance)?
- doublerabbit 6y agoOverhead. SQLite resources are a lot lower due to the database being a flatfile on the OS. It's only main resource is storage. MySQL is a application that not only requires configuration, tweaking, turning and tender-loving-care but consumes constant resources utilising the processor, memory and storage.
- acdha 6y agoMore standard without all of the correctness foot-guns, less to configure and operate, and it’s usually faster. MySQL has to do a lot of work running as a separate process, handling connections, etc. whereas SQLite is just doing file I/O in your current process.
- JAlexoid 6y agoLow maintenance overhead - SQLite, Firebird, Sybase are all like that.