On 31 May 2011, at 10:44pm, Nico Williams wrote: > You could rename the table and then delete from ... order by rowid asc > limit 1000, to delete 1000 rows at a time. Add in incremental > autovacuum and that might do the trick.
Would DELETE FROM myTable ORDER BY rowid DESC LIMIT 1 be any faster ? Remove the last records rather than the first ? Also, would dropping indexes before deleting the data be any faster ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
