On Oct 7, 2010, at 6:05 PM, Michele Pradella wrote: > I have a DB of about 3GB: the DB has about 23 millions of records. [..] > the statement is trying to delete about 5 millions records and it takes > about 4-5minutes. > Is there a way to try to speed up the DELETE?
Considering that you want to delete about a quarter of the records, perhaps it would be more efficient to recreate that table altogether, no? Pseudocode: create table new as select * from current where condition = keep; create index on new; drop table current; alter table rename new to current; _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
