On Mon, 2008-08-18 at 12:28 -0400, D. Richard Hipp wrote:

> Please try changing the last term as shown below (add a "+" before the  
> r-tree ID column):
> 
>       mapelements.ID = +mapelements_rtree.ID

Thanks a lot for your quick answer! Unfortunately, it didn't help.

What's interesting is that the first three rows are returned quickly
(sub 1 second), but then there's a very long pause until the remaining
rows are returned.

Thanks,
Tom


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to