On Fri, Feb 28, 2014 at 3:59 PM, L. Wood <lwoo...@live.com> wrote: > I can think of three ways: > Which way do you recommend? Are there other ways? >
i don't know that this would be better, but it's a different way: collect the list into a temp table with one field (the to-delete id), then do a DELETE FROM x WHERE id IN temptablename That might solve your list-length problem (can't say how performantly). -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users