On 9 Sep 2016, at 6:14pm, Венцислав Русев <ven...@proxima-3.com> wrote:
> I don't know if this will work for you, but can't you delete 1000 rows then > another 1000 ... until the table is empty. If you do do that, each 1000 rows should be deleted inside a transaction. So BEGIN DELETE FROM myTable WHERE ... END But SQLite has an optimization in for deleting all rows of a table DELETE FROM myTable // no "WHERE" clause which should mean it's faster to do it that way. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
