Agree. Thank you. Roman
________________________________________ From: sqlite-users [sqlite-users-boun...@mailinglists.sqlite.org] on behalf of Simon Slavin [slav...@bigfraud.org] Sent: Tuesday, May 01, 2018 12:50 PM To: SQLite mailing list Subject: Re: [sqlite] probably recursive? On 1 May 2018, at 5:34pm, Roman Fleysher <roman.fleys...@einstein.yu.edu> wrote: > With recursive route, I am thinking I need to build deleteList(x,y). Rather than actually delete rows, if you can, insert a new column in the table of all points. It starts with every row set to TRUE. When you decide a row doesn't count the value gets set to FALSE. This will be faster than doing the processing and file handling involved in deleting rows. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users