Suppose I have query that does: SELECT .... FROM table WHERE someinteger IN ( 2,18,19,340,1,72, 15 .... );
The list of numbers comes from a user selection, so it doesn't come from some other table. Would it make a big difference in performance if I pre-sort this list of numbers or does SQLITE automatically sort this (and perhaps maintains an index as well)? Thanks, Sander -- "And any fool knows a dog needs a home A shelter from pigs on the wing" _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
