Dear list, I have a program that materialize the subset of a database in a second database for future use.
To do so I create the database object on the OUTPUT database, create tables, create the indexes, and vacuum it just in the case I reused an old file. After I attach the INPUT db and I copy the useful lines. The input db is about 13GB, so not really large, however the step on this sql statement (where ? is of course binded to the db name) ATTACH DATABASE ? AS indb; requires several minutes (or more, it does not really seem to finish)! Besides sqlite3 already created a 5GB journal file. I am confused, why an attach database statement can be so slow? I am not sure if useful, but sqlite3 --version returns: 3.8.11.1 2015-07-29 20:00:57 cf538e2783e468bbc25e7cb2a9ee64d3e0e80b2f Your faithfully, Paolo
