On Mon, Sep 19, 2011 at 12:07 PM, Sreekumar TP <sreekumar...@gmail.com>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 > According to this page: http://orafaq.com/faq/difference_between_truncate_delete_and_drop_commands DROP has less overhead associated with it (e.g. no triggers fired). Note that TRUNCATE described on that page is (apparently) not supported in sqlite3 (or that's what my shell tells me). -- ----- stephan beal http://wanderinghorse.net/home/stephan/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users