4 ms·
This is so lazy as to be irritating to me. Magic pragmas with no explanation, no use of the important ones if you're going for max performance (synchronous and
by d1l 4y ago
This is so lazy as to be irritating to me. Magic pragmas with no explanation, no use of the important ones if you're going for max performance (synchronous and journal mode), no discussion of statement compilation and the benefits of plan caching, no discussion of indexes or transactions... Just garbage to make a lazy point that maybe SQLite is fast.
- cldellow 4y agoI agree that there's lots of room for improvement in both the benchmark and the exposition around it, but I disagree with: > no use of [...] synchronous and journal mode They enable both of these when configuring the connection: let connection_options = SqliteConnectOptions::from_str(&database_url)? .create_if_missing(true) .journal_mode(SqliteJournalMode::Wal) .synchronous(SqliteSynchronous::Normal) .busy_timeout(pool_timeout);