Re: [sqlite] New Optimizations in 3.7.16 -- Explain please?
> 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 used for sorting even if prior terms of the > index are constrained by IN operators in the WHERE clause. > > I use SELECT's using IN's... but I'm not seeing any improved performance. > > Anyone know exactly what is enhanced? or how it now allows indices to > be used where they couldn't be before? > > Thanks!! Anyone have any use-cases to show the new optimizations? Please? Thanks! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] New Optimizations in 3.7.16 -- Explain please?
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 used for sorting even if prior terms of the index are constrained by IN operators in the WHERE clause. I use SELECT's using IN's... but I'm not seeing any improved performance. Anyone know exactly what is enhanced? or how it now allows indices to be used where they couldn't be before? Thanks!! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users