Re: [sqlite] New Optimizations in 3.7.16 -- Explain please?

2013-04-03 Thread Patrick Herbst
> Can someone give me a case where the new changes make a difference in > relation to the following two changes: > > (from http://www.sqlite.org/releaselog/3_7_16.html) > - Enhance virtual tables so that they can potentially use an index > when the WHERE clause contains the IN operator. > - Allow

[sqlite] New Optimizations in 3.7.16 -- Explain please?

2013-03-25 Thread Patrick Herbst
Can someone give me a case where the new changes make a difference in relation to the following two changes: (from http://www.sqlite.org/releaselog/3_7_16.html) - Enhance virtual tables so that they can potentially use an index when the WHERE clause contains the IN operator. - Allow indices to be