SQLite Forum

Faster way to insert into WITHOUT ROWID table?
Login
I did some more experimenting, and I see the following instructions in the `EXPLAIN` output:

```
NoConflict
Halt
IdxInsert
```

I modified the implementation of the `NoConflict` to pass `bias = 1` to `sqlite3BtreeMovetoUnpacked`, since I'm inserting in order. And that gives quite a speed boost! (I can't exactly reproduce last week's timings, but I saw a ~20-30% speedup today)

Would it makes sense to add an `OPFLAG` for `NoConflict` that it's most likely an append? And emit it too in the parser, possibly only when using `INSERT INTO SELECT FROM` with a matching ordering?