4 ms·
What do you mean "transactions"? I agree with others that you may have other definitions of transaction. If you meant "I don't care about corruption, just make
by zinekeller 5y ago
What do you mean "transactions"? I agree with others that you may have other definitions of transaction. If you meant "I don't care about corruption, just make it as fast as possible" (this is mainly about about write performance though, since reads are already fast), then there are two PRAGMA commands related to this:
PRAGMA synchronous=OFF;
PRAGMA journal_mode=OFF;
The first one yields saving to the OS instead of SQLite verifying that it has been written properly (https://sqlite.org/pragma.html#pragma_synchronous https://sqlite.org/pragma.html#pragma_synchronous). The second one is basically turning off all journal capabilities, trading ACID for maximum performance (https://sqlite.org/pragma.html#pragma_journal_mode https://sqlite.org/pragma.html#pragma_journal_mode).