Thank you! This helped. didn't find this before. Best regards Daniel
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 > > ~Eric > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users