Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Inserting a billion rows in SQLite under a minute. Parent comment
For large deletes it is often better to move the rows that won't be deleted to a new table and rename the table when done.
With large updates it is important to look at the query plan and optimize it with good indexes. Batching also works well in this scenario.
There are no comments on this comment yet.
For large deletes it is often better to move the rows that won't be deleted to a new table and rename the table when done.
With large updates it is important to look at the query plan and optimize it with good indexes. Batching also works well in this scenario.