To keep some of my code simple I will need a WHERE clause of some kind, but sometimes it doesn't need to do anything. I was looking for some text I could use which would do nothing, but be simple for the analyser and the virtual machine. I had thought to use 'WHERE 1=1' but I wondered if the people in this list knew of something even faster.
It is not absolutely vital that this code execute as fast as possible. It's not going to be used to process millions of rows on a public-facing platform. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
