On Apr 25, 2008, at 9:19 AM, Eric Minbiole wrote: >> 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 >
See also check-in [5026] http://www.sqlite.org/cvstrac/chngview?cn=5026 which should fix the problem. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
