explore ATTACH

[avinassh]

https://www.sqlite.org/lang_attach.html

[milahu]

how should attach help with insert speed?

attach can be useful for adding indexes to read-only dbs

[ddevienne]

Indeed, attach won't help performance.

And no, you can't create index in one DB, for a table in another DB. They must be in the same DB.