Re: [sqlite] [patch 2/2] move "const" out of loop in "WHERE const AND expr"

2013-11-03 Thread Yuriy Kaminskiy
On 2012/04/08 Yuriy Kaminskiy wrote: > On 2011/10/23, Yuriy Kaminskiy wrote: >> 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:

Re: [sqlite] [patch 2/2] move "const" out of loop in "WHERE const AND expr"

2012-04-07 Thread Yuriy Kaminskiy
On 2011/10/23, Yuriy Kaminskiy wrote: > 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

Re: [sqlite] [patch 2/2] move "const" out of loop in "WHERE const AND expr"

2011-12-06 Thread Yuriy Kaminskiy
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 >>>

Re: [sqlite] [patch 2/2] move "const" out of loop in "WHERE const AND expr"

2011-11-03 Thread Yuriy Kaminskiy
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

[sqlite] [patch 2/2] move "const" out of loop in "WHERE const AND expr"

2011-10-23 Thread Yuriy Kaminskiy
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