On 17 August 2015 at 14:52, Paolo Bolzoni <paolo.bolzoni.brown at gmail.com> wrote:
> 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. > Are you sure it's the process trying to attach the DB that created the 5GB journal? ie. is it possible the 5GB journal is a hot journal leftover from something else, and needs to be rolled back? Not sure if that happens during ATTACH or not... -Rowan
