Re:Batch size one billion: SQLite insert speedups, from the ...
by voidstarcpp on Tuesday September 26, 2023 @12:52PM
(#37662141)
In my limited experiments WAL wasn't faster for high-row-speed writes.
When rows/s are maximized SQLite is CPU limited by internal bytecode operations rather than waiting for disk stuff.
Re:Batch size one billion: SQLite insert speedups, from the ...
by argiopetech on Tuesday September 26, 2023 @03:50PM
(#37664936)
Too late to edit:
This should have said "at run time", as it's set by making a relatively normal (can't be inside a transaction) SQL query.
[0] https://www.sqlite.org/wal.html