Batch size one billion: SQLite insert speedups, from the useful to the absurd

Re:Batch size one billion: SQLite insert speedups, from the ... by voidstarcpp on Tuesday September 26, 2023 @12:35PM (#37661841)

PostgreSQL supports heap tables, which should blow away SQLite's mandatory clustered index tables in an unindexed insert test.

[ Parent | on HN ]

Re:Batch size one billion: SQLite insert speedups, from the ... by chmaynard on Tuesday September 26, 2023 @01:39PM (#37662933)

In SQLite, would declaring the table without a rowid obviate the index? For example:

    CREATE TABLE IF NOT EXISTS integers
    (
       value INTEGER NOT NULL, 
    )
    WITHOUT ROWID;

[ Parent | on HN ]