Hello Jay, Thursday, March 2, 2006, 11:20:50 AM, you wrote:
>> 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 ? JS> If you delete ALL the data you can just delete the database file JS> then create a new empty one. That's kind of not his point. If he deletes all but one record the same thing applies. His question is valid if true. I've found vacuum to be be slow also but, don't know how to quantify it. -- Best regards, Teg mailto:[EMAIL PROTECTED]
