On Aug 3, 2018, at 1:36 PM, Shevek <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
