SQLite Forum

Faster way to insert into WITHOUT ROWID table?
Login
I would guess it's often useful in these conditions:

 1. It is an `INSERT INTO SELECT FROM` (i.e. the target table is likely empty)
 2. The target table is `WITHOUT ROWID` or it has a related index
 3. The `SELECT FROM` is ordered in the same way as the table or index


Regardless of what you decide regarding implementation (or deciding not to), thank you for answering my questions on this topic.