On 19 Sep 2011, at 11:07am, Sreekumar TP wrote: > Which would be the quick way to clear all records in a table ( assumming > 100,000 records) ? > > 1. Delete * from table_name > 2. DROP TABLE table_name followed by CREATE TABLE
Faster to DROP and CREATE. Note that you will have to CREATE your INDEXes too, after CREATEing the TABLE. It may or may not speed things up if you do a VACUUM between the DROP and CREATE. It should make the file size smaller. There will be problems if you are using FOREIGN KEYs. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users