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.
As I wrote, delete / drop takes a lot of time (try it on a big db). I need
a way to say "quick drop everything", there is nothing to worry about.
Vacuum is instant (after drop tables), which is normal for an empty db.
While space is not a major problem, in my model it is at least unusual.
I use sqlite as file format in an append only model; file size (pages) is
a direct measure of how much data is available.
In this model, I need the "truncate" operation.
I can live with my workaround...
Regards,
Gabriel
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
