> 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