On Thu, 24 Oct 2013 21:40:32 -0400, Igor Tandetnik <i...@tandetnik.org> wrote:
>On 10/24/2013 9:17 PM, David Bicking wrote: >> But I think sqlite would notice that the subquery was the same in the >> UPDATE statement that Igor T gave and not run it twice > >I don't believe SQLite is quite that smart. It wasn't last time I >checked. I think it will, too, run the subquery twice, but since it uses >an index, that should be reasonably fast. If the subquery runs twice, the relevant pages will almost certainly be in the page cache, which makes it almost as fast as when the second run was optimized out. -- Groet, Cordialement, Pozdrawiam, Regards, Kees Nuyt _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users