On Nov 7, 2009, at 10:54 AM, Simon Davies wrote: > > I used 10,000 entries, and it returned in a few seconds... (using > 3.6.19) > > But there does appear to be a problem: > sqlite> select count(*) from test1 natural join test2; > 10 > sqlite> select count(*) from test1 natural join test1; > 100
Try that again using 3.6.20. That problem was fixed by http://www.sqlite.org/src/vinfo/ 6fe63711754on 2009-10-19. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
