On Thu, 27 Jun 2013 12:05:00 +0200 Patrik Nilsson <nipatriknils...@gmail.com> wrote:
> Now I'm doing: "insert or ignore into table_test (id) values (1)" and > then issue an update statement. I think "insert or update" will > increase performance. The "insert or update" statement is an unnecessary complication. It adds no expressive power to the language; the effect is readily expressed today with an update statement followed by an insert. Performance is not a reason to modify the grammar. It's simply up to the implementation to divine the shortest physical path to the logically expressed outcome. --jkl _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users