Agree. Thank you. Roman
________________________________________ From: sqlite-users [[email protected]] on behalf of Simon Slavin [[email protected]] 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 <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
