On 12 Jul 2018, at 8:30am, Cecil Westerhof <cldwester...@gmail.com> wrote:
> I am not quit happy with this. Would it be better to split it in two > queries and feed the result of the first to the second? I would guess that it will run faster. How much faster depends on how many rows there are in the table. Naturally I would say this since I am a fan of multiple short SQL commands rather than one big complicated one. You could enclose the two queries in a transaction if you're worried about something sneaking between them. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users