On 3 Mar 2017, at 10:53am, Dave Blake <davebl...@kodi.tv> wrote: > DELETE FROM table1 WHERE id1 NOT IN (SELECT id1 FROM tmp_keep); > > But this becomes inefficient when tmp_keep is large.
Do you have an appropriate index on tmp_keep ? CREATE INDEX tk_id1 ON tmp_keep (id1) then try it again. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users