Yuriy Kaminskiy wrote: > Yuriy Kaminskiy wrote: >> Yuriy Kaminskiy wrote: >>> When WHERE condition is constant, there are no need to evaluate and check >>> it for >>> each row. It works, but only partially: >> ... >>> [In fact, you can move out out loop not only *whole* constant WHERE, but >>> also >>> all constant AND terms of WHERE, like this: >>> SELECT * FROM t WHERE const1 AND notconst AND const2 -> >>> SELECT * FROM (SELECT * FROM t WHERE notconst) WHERE const1 AND const2 >>> I'll take a shot on that later.] >> Here it goes. >> >> Prerequisite: previous patch. >> Passes quick regression test (make test). >> Possible problem: short-circuits evaluation. Should not be problem, IMO, as >> only >> constants references? Please verify. > > Ping. Ping.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users