4 ms·
Maybe this is a stupid question, but why is it that MySql can write so much faster than SQLite?
by chacham15 13y ago
Maybe this is a stupid question, but why is it that MySql can write so much faster than SQLite?
- dvhh 13y agoMysql can cache to memory and and defer write operation for latter the most used storage engine (MyIsam) seems to be less resilient and have limited feature compared to sqlite, plus SQLite support for transaction bring some latency and is designed to be resistant to corruption due to power loss or unexpected program crash. A more fair comparison would be memory stored database benchmark.
- morgo 13y agoRow-level locking, mvcc, multiple write threads. Mysql (default Innodb engine) is actually pretty good at io scalability since ~ 5.5 (2010). We have google, percona, Facebook, oracle to thank for this.