Re:Learning a few things about running SQLite
by cogman10 on Friday July 17, 2026 @03:53PM
(#48951600)
Yeah, I think anyone that's done significant database work has come to the understanding that large updates need to be done in batches, otherwise you nuke performance.
Once you get to about 1M rows of data, batching is essential.
Once you get to about 1M rows of data, batching is essential.