> Keith Medcalf wrote: > .. Am I doing something wrong here .. No! The query with order by + limit 1 is superior, also in my test.
Still I am surprised that the rtree extension is available by default (at least in the sqlite version 3.25 command line) _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users