On Aug 3, 2018, at 1:36 PM, Shevek <sql...@anarres.org> wrote: > > the database is read-only
In that case, I’d just create a :memory: DB on application startup, attach to the disk copy, use the INSERT FROM … SELECT pattern [1] to clone the data content within a single transaction, create the indexes, and detach from the on-disk copy of the DB. [1]: https://stackoverflow.com/a/4291203 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
