On Fri, May 9, 2014 at 8:36 AM, Andy Goth <andrew.m.g...@gmail.com> wrote:
> On 5/8/2014 10:11 AM, Jim Morris wrote: > >> To improve efficiency you could add "where 1=2" to avoid returning any >> rows. Should just check validity. >> > > This being SQLite, as previously discussed, you could say "where 0" :^) i don't think a WHERE is necessary to improve the efficiency. The statement only gets prepared, not stepped, and i would not expect any analysis of results until the first step() (but maybe i'm assuming too much). -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
