> This works great but when I upgraded from 3.5.7 to 3.5.8 the speed of > this select went from 0.2s to around 1 minute. And 3.5.8 is stealing > ALOT more memory.
D. Richard Hipp had a very helpful work-around for this issue, by simply rearranging the terms of your join's ON clause. Take a look at this thread for details: http://www.mail-archive.com/sqlite-users%40sqlite.org/msg33267.html ~Eric _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users