On 19 Jul 2012, at 9:22am, Gabriel Corneanu <[email protected]> wrote:
> I have the following scenario: I need to "clear"/"initialize" a db file > while potential readers are active (polling for data). > The "normal" way to do it is begin a transaction, drop all tables, recreate > tables, commit (vacuum to regain space). Rather than dropping all tables, why not just use DELETE FROM TABLE myTable with no clauses ? Also, I would guess that the thing which is taking most of the time is the VACUUM command. Do you really need it ? Are you very short of filespace ? Are you about to make special backup copies of the newly empty tables ? Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
