RE: [sqlite] Vacuum Command

2006-05-02 Thread George Mavroudes
: [sqlite] Vacuum Command I am new to SQLITE but in some other database vacuum want to have full controll test with Transaction as BEGIN EXCLUSIVE TRANSACTION test VACUUM [tableName] END TRANSACTION test // Anders George Mavroudes skrev: > Sorry for the omission and thanks for the qu

RE: [sqlite] Vacuum Command

2006-05-02 Thread George Mavroudes
] and then execute the VACUUM command, will this temporarily delete the table (causing a SCHEMA_CHANGE) and then add this table back into the db? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 02, 2006 10:08 AM To: George Mavroudes Subject: Re

[sqlite] Vacuum Command

2006-05-02 Thread George Mavroudes
hi, - I am pretty new to SQLITE and I am having a problem with the following sequence of commands: - DELETE FROM [tableName] - VACUUM [tableName] The project I am working on has multiple threads Reading / Writing to this table and other tables, and after