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
