Thanks for this clarification. Wouldn't SQLite simply rewrite my IN-list query, transparently, as an equijoin against a transient table that has been populated with the values in the IN-list? I don't understand why the IN-list should have to be avoided.
Thanks Tim Romano On 1/27/2010 12:28 AM, Jay A. Kreibich wrote: > [....] temp database are always cleaned up when the database > connection is closed. And since temp tables and indexes go into the > temp database, and not your main active database, there is no > long-term maintenance. > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users