-----Ursprüngliche Nachricht----- Von: Jay Sprenkle [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 2. März 2006 17:21 An: sqlite-users@sqlite.org Betreff: Re: [sqlite] Vacuum slow
> But I wonder : > > if I have a db ~ 1gb and I delete all the data in the tables ( db is > than nearly empty ) > Issuing a vacuum command takes a long time ( several minutes ). > Why ? > Is there a way to "vacuum" faster ? If you delete ALL the data you can just delete the database file then create a new empty one. I do not delete all the data but a great part of it. And I want to preserve all the tables ( even empty ) in the db. Recreating a new db means recreating all the tables , triggers , ...